@excel_with_kyle: Extracting Text using =LEFT, =RIGHT, and =MID together #excel #exceltricks #exceltutorial #data #coding

Excel With Kyle
Excel With Kyle
Open In TikTok:
Region: US
Wednesday 16 July 2025 23:30:00 GMT
52861
2406
41
161

Music

Download

Comments

excel_with_kyle
Excel With Kyle :
Just as a side note, there's a lot of different ways to do this type of extraction, so let me know in the comments what your preferred way would be!
2025-07-17 00:18:49
6
._daniel_armando
_Daniel :
Thoughts on regextract? I use this method shown and textbefores/afters but I’m interested in seeing if other people have started to use regextract instead
2025-07-17 12:25:26
1
olubukolafashipe
Bukkie :
Can’t flash fill work for this?
2025-07-23 06:34:11
0
noir_hood_cat
NoirHoodCat :
why not a custom vba function using regex?
2025-07-20 15:42:18
0
alannazermeno
Alanna Zermeno :
Could this be done in power query?
2025-07-18 01:25:44
0
gtmaitunxxq
gtmaitunxxq :
Do you have somewhere I can download the file for practice?
2025-07-17 01:05:25
0
nevin.sandra
Nevin Sandra :
Ctrl find replace Delivery #: replace with Delivery #:; Text to column to separate Text to column "," separator
2025-08-08 18:53:42
2
amiljan024
AJ :
Do you have tutorials for starters ??
2025-08-09 15:13:36
0
ugm_873
Udana :
Amazing and thank you
2025-07-17 18:22:57
1
zemteddy
ዘመ፺ | Žëmĕñ :
🔥🔥🔥
2025-07-19 18:29:48
0
fingerhat4
Fingerhat :
=REGEXEXTRACT(REGEXEXTRACT(PROPER(A1),"Delivery#: [0-9]+"),"\d+")
2025-07-21 16:17:11
1
maliixaan
SomaliSotans :
I got it in 2 steps 1- I used this formula =TextAfter(A2, "Delivery #:") 2- =Iferror(Left(B2, Find(",",B2)-1),B2)
2025-07-19 05:49:40
0
tiktoker100005
TikToker :
Make a video showing how to make excel not ass with large data.
2025-07-18 20:53:09
0
To see more videos from user @excel_with_kyle, please go to the Tikwm homepage.

Other Videos


About