🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzitem.info/door/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@JenniferDonow
6 ай бұрын
Because I can be a tad slow, I have come back to this video several times. It is super helpful, plus Kevin explains things in a way that I hear. Thanks!
@clprinke
18 күн бұрын
Love your content!!! Thanks for helping us non techies, you make it simple.
@DaudiX
Жыл бұрын
Kevin, I was expecting some complex formula that I have to cram…this is so straight forward I will remember it! Thanks a million! 🙌🏾
@ghenergy
Жыл бұрын
Kevin thanks for this tip. You are well on your way to becoming a great leader within the technical community. I'm a senior recruiter for one of the larger EPC companies within the industrial construction sector and I deal directly with the VP, Info Mgmt • Project Execution Services within EPC in our company. I'll follow more of your excellent training sessions.
@scarpoochie
4 ай бұрын
This is perfection! Thank you, Kevin, for saving me tons of time today. You're the best.
@bernadettepesce7044
3 ай бұрын
What a timesaver! I have a huge list that I need to alphasort. Kevin, thank you SO much.
@coolpool5277
Жыл бұрын
Keving, you have no idea how you make lives of people like me so easy. Good on you
@HoneyMrsBons
Жыл бұрын
I've watched this a minute ago, and Wow it really works. Thanks
@deepanshusood
2 жыл бұрын
I am trying this on Microsoft 365 for Mac, using Table method and it just won't intelligently detect names. Okay So I found out instead of Command you are supposed to use control-E and it worked. Thanks a lot for this
@Monika-nb6ur
3 жыл бұрын
I'm trying this, but it's not working! It there something with the settings we have to do after changing the data into a table?
@mulavangue
Жыл бұрын
THANK YOU VERY MUCH FOR SHARING THIS TIP.... YOU SAVED MY DAY.
@osrsyambo
Жыл бұрын
Is there a way to do this with a formula? Like without using the table?
@timetowatch_francois
Жыл бұрын
Saved soooooo much time!!! Thanks for sharing! and ... you're creeping up on 2M Subs!!! 👏🏼🤩 Hope you hit it soon. I know I added my name to your list 😄👍🏼
@jarvisadamsedu4270
Жыл бұрын
You saved me a boat load of time. Thank you!
@danaredford5782
3 жыл бұрын
How cool, just had a need and it worked like a charm! Thanks for sharing!
@aliala9844
3 жыл бұрын
You saved me Man. Thank you.
@memel2853
8 ай бұрын
Great video. Quick and simple. Thanks
@questionresearch8721
2 жыл бұрын
Thank you this helps so much ❤️
@jenniferdonow5036
11 ай бұрын
This was super helpful.
@ColleenSlocombe-x7q
3 ай бұрын
Life Saver, so quick!
@marianezulueta8999
4 ай бұрын
Thank you so much, super helpful ❤
@nextgengaming6614
Ай бұрын
Thank you I didn't know it would be this easy
@mickeydeadeyes7686
Жыл бұрын
Just saved me like an hour...amazing!
@jamalwhitney8203
6 ай бұрын
saved me a ton of time. thank you!
@kayjayteewol
Жыл бұрын
Woooooooow! Impressive! Thank you so much for this tutorial. It really helped me save time and energy. Thank youuuuuu =)
@joshthielbar1
Жыл бұрын
This was awesome. Thank you
@odokonyerorobinson2475
2 жыл бұрын
YOU ARE AMAZING KEVIN I LIKE THAT
@nonethorito3161
7 ай бұрын
it really works..thanks for the help!
@arrelmaximo8942
Жыл бұрын
You just earned a subscriber.
@28peas
2 жыл бұрын
Hey, thanks a ton for that great trick! Ps- In my case, I got the middle name & the last name together in the Lastname column. But it worked & saved me a lot of time. Thanks.
@johnpadgettii9998
Жыл бұрын
Thank you and well done!
@Mooshoes
10 ай бұрын
Thank you for the tips here, you explained it very well.
@yonasmisganaw6023
2 жыл бұрын
Thanks bro the easiest i have seen!
@melsazaspanishmark7994
4 ай бұрын
The Ctrl E worked thank you
@Houston87651
Жыл бұрын
Thank you for this video, it was SUPER helpful.
@HoneyMrsBons
Жыл бұрын
I have difficulties on formulas thanks I found your Videos
@beverlygilalta1420
11 ай бұрын
Thank you as always
@terrycontreras3704
Жыл бұрын
Kudos 2/U! great video....🙌❤🙌
@cindywright1564
Жыл бұрын
thank you, thank you, thank you, thank you to the umpteenth power!
@maichannel1050
5 ай бұрын
This works wonders! Thank you so much!
@ValorantRivals
2 жыл бұрын
Bro, this is amazing.... omg!
@1969jflo
Жыл бұрын
Thank you so much, this save me a days work.
@QueenChichih
7 ай бұрын
Thank you so much for sharing this tip.
@mannyvidis4533
Жыл бұрын
Hi Kevin I am a recent convert to your web site and you've helped out of several jams. Now I have one that has totally stymied me. A friend of mine wants me to address 150 envelopes for her son's wedding which sounds simple enough but the list she is going to send me is in word and as far as I know it has no formatting. I think she just types an address then skips a line and types another address, etc. I thought and thought about it but can come up with any way to make a spread sheet that I can use to address the envelopes. Your advice will be gratefully received. Thanks. Manny-
@SNeaker328
Жыл бұрын
Something I have not been able to find anywhere is how to separate out the names when there are two names in the same cell, for instance a married couple that has two last names like "Smith, Mike & Johnson, Emma."
@cammarshall2376
Жыл бұрын
Quick question, what happens if it is last name, e.g Mary Van Der Gough or double barrel last name Brown-Wright?
@joshuaosoriobearriver6815
Жыл бұрын
thank you sir. great help. God Bless
@yonasmisganaw6023
2 жыл бұрын
can u make video on how to add two service years put in this format and if i want to add them any suggestion you might have it will be usefull,Thanks 2yrs,2m,2days 3yrs,2m,2days
@m.usmanulasad9403
4 ай бұрын
Brother thanks a looooot.❤❤❤❤❤
@nkazindlov9689
Жыл бұрын
You are a life saver
@ossieocasio-falu4278
Жыл бұрын
very helpful thanks
@solutions4u241
Жыл бұрын
It is a very useful info ,Thank youuuuu
@RobinGlassey
2 жыл бұрын
Looks like a great idea, but this didn't work for me when I tried it.
@pschiavitti6688
Жыл бұрын
Genius!! Thank you!!
@sakisl7739
Жыл бұрын
Quite useful sir ! Thank you!
@sofiatapia4058
2 жыл бұрын
You're awesome! Thank you so much!
@gerbherb8215
7 ай бұрын
So what do we do with the "Benson" of Margaret Miller? We just forget that it is part of her name? And what if someone has a first name made out of two words? Or a last name made out of two or more words? Or a combination of first and last names with more words? And have you ever seen people who have nobility names?
@juliagarrido9297
3 жыл бұрын
Super easy! Thank you so much
@pattylynch-independentprin6323
3 жыл бұрын
This is outstanding!! thank you!!!
@avinashbarge9869
9 ай бұрын
Good evening sir. i like your video . i understand this video . but i am confuse this practical 👉 How to Sort Personal Name & Firm name in Excel sheet i am eagerly waiting for your comment box sir.
@StopForeclosureMortgage
7 ай бұрын
I ran a do not call phone number list, I have 4 columns, I want to delete the 'found' phone numbers. When I highlight them in red, the entire 'found, not found' columns go read as well. I want to know how to only highlight the 'found' items, then I want to know how to deleted them all at once please.
@fernzfernandez3050
2 жыл бұрын
Wow.. great help... thank you....
@christianfamilychurchcentu4821
3 жыл бұрын
How do I separate First Name from Last Name in Excel on my Mac
@viktoriyafriedman6087
Жыл бұрын
It’s great, but I have over 10K rows with some Jr. Designations that pulled into Last name column. Also, some double last names..
@janinegreen994
2 жыл бұрын
When I highlighted the data it wouldn’t allow me to click on the table icon in data group.
@codewithyemi
4 жыл бұрын
It's not working for me. I wonder what could be the problem.
@wendywong-you
Жыл бұрын
Hi Kevin , could you tell me how to split my excel that has full address with a comma only after city, I can move the state and zip, but I can't get the city away from the address. I'm going nuts trying to get this done. even asked ChatGPT, still can't get it. I know it's an easy fix. watched many youtube videos but nothing is working. Please help . thanks wendy
@dymierefinch2655
Жыл бұрын
Easiest way I have seen to date.
@CreativeEdge100
4 жыл бұрын
Thanks! Very helpful.
@mhaymontilla3608
2 жыл бұрын
hi do you have easy way to separate full name if the person have 2 names? thanks
@gracearana7957
2 жыл бұрын
Thank you!!!!
@lizmcneill1641
2 жыл бұрын
Amazing thanks
@zainab_saeed
2 жыл бұрын
Thanks 👍
@Brtlady
3 жыл бұрын
Magic! Thanks a lot
@lynnemartineau1538
3 жыл бұрын
WOW best one ever!
@kornerkorner8039
Жыл бұрын
What if there’s two names in 1 cell. Those two names are separated by commas
@mazeembutt1
3 жыл бұрын
won't do it in 2010 excel
@johnpries9540
6 ай бұрын
Any idea why all my last names filled misspelled??
@LearnTeaching-o9f
Жыл бұрын
Very nice
@Saidishakart
Жыл бұрын
Thanks
@PeterZ1959
Жыл бұрын
Did not work for me. Using version 16.76 Excel for MAC
@cassieklein6772
3 ай бұрын
What if Excel doesn't auto detect the information?
@Sged-San
8 ай бұрын
Thank u sir
@wallis442
3 жыл бұрын
Awesome 👌.
@christinac2012
2 жыл бұрын
What if you have commas in between? Does it matter? 🤔
@cindygibbs8281
2 жыл бұрын
My first names are spelled wrong. How can I correct them....
@jamescapone8175
4 жыл бұрын
I couldn't do it
@theresasouthern8631
2 жыл бұрын
This doesn't work for me. Maybe because I use MS Office for Mac.
@truonghoanghaminh4839
4 жыл бұрын
Thanks ad
@meganphannguyen2284
4 жыл бұрын
We can't do it on online office, can we?
@abrahamsantana1016
4 жыл бұрын
How do you separate two last names and suffixes?
@christinalee75
3 жыл бұрын
I couldn't get this to work either
@demngujo8959
3 жыл бұрын
same
@nazmulislamrabbi2643
2 жыл бұрын
How about Last,middle and First name everyone doing the same
Пікірлер: 169