Ask McKayla | Excel
Region: US
Monday 07 March 2022 03:32:22 GMT
542964
24063
226
1181
Music
Download
Comments
ElephantSanctuary :
text to column is faster🥰
2022-03-07 07:18:36
209
Somatra Sourng :
Couldn’t you also achieve using flash fill?
2022-03-07 06:49:38
40
Sam Ferree :
people who don't consider excel programming are wrong.
2022-03-12 03:26:49
4
geekahedron :
Type the first name, Ctrl E, done
2022-03-12 03:16:21
15
FisherPric3 :
I'm always happy to learn new excel trick but can't this particular thing also be done with text to columns and the space as the delimeter?
2022-03-07 07:07:09
14
Andy :
flash fill or use the delimiter text to column. that formula is cool, but you can spend less time other ways
2022-03-12 02:02:56
6
H4yT3r :
I learned on the other day, first name then select next cell, ctrl+e
2022-03-12 18:33:48
1
techwithgabi :
literally thank you for your videos
2022-03-07 07:58:14
2
Hellhoundmom :
I've used this formula so many times! Love it!
2022-03-15 20:56:28
1
ChaoticGray :
Ok, but space delimited Text to Columns would be faster… love the other videos though
2022-03-13 05:07:10
1
🦋 TheMindful88 🦋 :
Sweet!!!
2022-03-15 12:43:09
1
Tiffer2005 :
How can I make all cells negative at once
2022-03-13 23:20:29
1
VonZuben :
Great tip! Lots of comments from ppl who seem to only ever have to manipulate data once, though... I need live formulas almost all the time!
2022-03-16 13:50:29
1
Big Frickin Dude :
What did you click to get it to do all the cells down? Normally I have to find the + in the corner and drag it.
2022-03-13 16:17:54
1
heavy.c.204_ :
Awesome! I needed something like this
2022-03-13 19:43:09
1
Tim of The Redland :
Microsoft might want to look into this. She's on to a great idea.
2022-03-12 19:10:26
1
SN - iykyk :
i admit to use Len (so it doesn't matter if I do mid, left or right)
2022-03-13 00:44:35
1
syfer :
also just type in "Andrea" and flash fill, same thing
2022-03-07 15:52:17
2
BBDB :
Omg
2022-03-13 21:00:29
1
Pete :
Huge help thanks
2022-03-13 23:55:43
1
Andrew Kunisawa :
I like your positive responses
2022-03-13 15:45:03
2
Avery :
Or just use Split lol
2022-03-12 01:13:46
1
Friendlysavage :
Is there a way to find the second space?
2022-03-07 06:32:30
1
Just Another Zach :
*reads comments* Hmm, I wonder if there's some other method for when my data doesn't change? 🤔 😂
2022-03-28 07:47:23
1
lilu72404 :
Yay I’m so glad I came across your vids! I recently moved up at work into an excel-heavy position and I’m anxious to learn more.
2022-03-13 04:22:58
1
To see more videos from user @askmckayla, please go to the Tikwm
homepage.
