Thank you - this is by far the easiest tutorial I have found. I rarely have to do it and have to search to figure out the answer - thanks for making my job easier today!
@FrankMLoSchiavo
Жыл бұрын
I'm so glad it helped! Thanks for letting me know :)
@Drayafenandez
3 жыл бұрын
Thank you! This was very helpful. I don't normally need to use Excel for work so you just saved me about an hour of time!!!
@FrankMLoSchiavo
3 жыл бұрын
Glad to help :)
@erikachubb8140
Жыл бұрын
Thank you so much. I read and tried everyone elses suggestions and they didn't work. Your video worked. Thank you so much. Im saving your video.
@FrankMLoSchiavo
Жыл бұрын
I'm glad the video helped you :)
@CMGrant07
3 жыл бұрын
This video has been so helpful to me. Thank you!
@FrankMLoSchiavo
3 жыл бұрын
You're welcome! Be sure to check out Solution #2, which uses Flash Fill. It's really a better solution. Flash Fill is like magic! Here's the link: kzitem.info/news/bejne/06idza6mmoeTam0
@jacquelinepasker7308
3 жыл бұрын
This was so helpful - thank you! Nice and easy to follow along to.
@FrankMLoSchiavo
3 жыл бұрын
Happy to help!
@inesboisrond8122
Ай бұрын
This was great and very helpful, clear and easy to understand.
@FrankMLoSchiavo
Ай бұрын
I'm glad the video was helpful! Thanks for taking the time to let me know :)
@Meggamuffin
11 ай бұрын
Just saved from having to redo an entire spread sheet! Thank you!!!
@FrankMLoSchiavo
11 ай бұрын
I'm so glad the video helped you! Thx for letting me know :)
@dandelacruz4772
8 ай бұрын
I got it, yay. You are a good teacher. God bless you, 🙏🏼.
@FrankMLoSchiavo
8 ай бұрын
I'm glad to help! Thx :)
@EdTechSpokane
3 жыл бұрын
That was exactly what I needed. Thanks
@FrankMLoSchiavo
3 жыл бұрын
My pleasure.
@gooddeeds3289
3 жыл бұрын
You made so easy to understand 👍
@FrankMLoSchiavo
3 жыл бұрын
Thanks for letting me know that. I appreciate it! If you can, share the video with others :)
@AjayAgrawal16
Жыл бұрын
Very easy to understand thanks
@FrankMLoSchiavo
Жыл бұрын
You're welcome :)
@maricrismurrell
2 жыл бұрын
soooo helpful Thank you!
@FrankMLoSchiavo
2 жыл бұрын
You are soooo welcome, lol!
@ronaldoplania520
2 жыл бұрын
Many thanks for this information bro
@FrankMLoSchiavo
2 жыл бұрын
My pleasure. Thx for posting :)
@slwplace
2 жыл бұрын
Yay! This was easy to follow and helped me with a huge list of names! But some people have 2, 3 or 4 middle names between first and last (all in the same cell). What do I do about that?! Thanks a million.
@FrankMLoSchiavo
2 жыл бұрын
Hi Sarah. I have a video that describes using flash fill. That might help you in this situation. Watch the entire video, but the part that might help you most starts around 4:45. Here's the video: kzitem.info/news/bejne/06idza6mmoeTam0
@WilliamsonIns
2 жыл бұрын
Super helpful! Thank you so much for this. 👍
@FrankMLoSchiavo
2 жыл бұрын
My pleasure. Glad it helped you.
@CebastyanB
4 жыл бұрын
Hello, I work for American Airlines as an Executive Assistant and I use Excel quite frequently however I'm a novice. Your video was so easy to understand and I've watched a million videos to help me through certain processes! Yours was the best I've seen thus far. Great Job and I really appreciate you - I'll be sharing your details with all my Admins as well!
@FrankMLoSchiavo
4 жыл бұрын
I'm so glad the video helped you. Thanks for posting such supportive comments. I appreciate it!
@estuardoruiz5373
3 жыл бұрын
Great walk through. Thank you!
@FrankMLoSchiavo
3 жыл бұрын
You're welcome!
@FrankMLoSchiavo
3 жыл бұрын
By the way, if you liked that video, check out this one...kzitem.info/news/bejne/06idza6mmoeTam0 It discusses FLASH FILL, which can accomplish the same name conversion much more easily.
@carmellaberroya9256
2 жыл бұрын
Thank you so much!!!
@FrankMLoSchiavo
2 жыл бұрын
You're welcome. Consider checking out a second (and better) solution that I posted for converting first-last to last-first. You'll find it here. kzitem.info/news/bejne/06idza6mmoeTam0
@timclark9734
3 жыл бұрын
Just a simple thanks
@FrankMLoSchiavo
3 жыл бұрын
You're welcome!
@leebailey186
2 жыл бұрын
Wow, thanks so much!!!
@FrankMLoSchiavo
2 жыл бұрын
Thanks! By the way, I have a video that shows a simpler solution, using Flash Fill. Check it out: kzitem.info/news/bejne/06idza6mmoeTam0
@vincenzonelli6921
Жыл бұрын
I have multiple names in a single cell (First Last, First Last, First Last). I need to change the cell to (Last, First; Last, First; Last, First). Do you have video on this or a suggestion?
@FrankMLoSchiavo
Жыл бұрын
I have a video that shows how to use flash fill as a second solution to this type of problem. Take a look at the video and see if flash fill might work in your situation. Here's the link: kzitem.info/news/bejne/06idza6mmoeTam0
@matthewbrodowski
2 жыл бұрын
can you make this a running formula? I regularly add names to a list. It would be beneficial to have this automatically happen without having to go back to the data/ column text to run this every time... I just want it to automatically take the name John, Doe and make is Doe, John everytime I add a new name. It seems that i can currently do that... The =concate() formula pulls from the (firstname), (lastname) columns, which derive their values from manually running the DATA>text to column process you just walked us through.. This is the process im trying to Automate...
@FrankMLoSchiavo
2 жыл бұрын
Yeah, that's a good idea! You can use the autofill handlebar to copy that same concat function down as far as you'd like. One problem you'll run into is seeing the comma will appear in the cells corresponding to the rows that have no names entered yet. You can use conditional formatting on those cells to get rid of the commas until the names are entered, but that's a whole other topic altogether. Good luck!
@kevinfredawu3607
3 жыл бұрын
Many thanks!
@FrankMLoSchiavo
3 жыл бұрын
You're welcome!
@rjminton534
2 жыл бұрын
Thank you so much 😊
@FrankMLoSchiavo
2 жыл бұрын
My pleasure, my friend. Thx for leaving a comment :)
@John_GGG
Жыл бұрын
If I need to repeat this every month, with a new list of names, is there a way to do this without going through all the steps again?
@FrankMLoSchiavo
Жыл бұрын
I'm not sure of an easy way to reuse the text-to-columns procedure without going through those steps again. HOWEVER, I recommend that you check out my video that shows a second solution to this issue using FLASH FILL, kzitem.info/news/bejne/06idza6mmoeTam0
@robpgh159
Жыл бұрын
Yes, look up MACROs on excel
@FrankMLoSchiavo
Жыл бұрын
@@robpgh159 That's a good idea. In fact, I have a video that shows how to record, save, and run a macro, kzitem.info/news/bejne/1H-flqukcn53dWk
@muhammadramdan81
3 жыл бұрын
Thank you ❤️❤️❤️
@FrankMLoSchiavo
3 жыл бұрын
You're welcome.
@butterflydreams7920
4 жыл бұрын
Saving my job lol
@aliceriley683
3 жыл бұрын
Thank you.
@FrankMLoSchiavo
3 жыл бұрын
My pleasure. Please share the video with others :)
@debbieryckman9143
2 жыл бұрын
Hello Frank. Your video was very helpful in finding a solution to name sorting. It did not work on the final step for me and I wonder if it is because I exported a csv file, not excel file. I need a csv file format because it needs to be uploaded to an accounting software program. What would be your suggestions in this case? I was able to split the first name and the last name into 2 columns, but then to use the contat function it didn't seem to work. Thank you.
@FrankMLoSchiavo
2 жыл бұрын
Hi Debbie. First, be sure you're using Excel (as opposed to google sheets, etc.) and be sure you're spelling the function name correctly (concat instead of contat). We know the Excel concat function works (I prove that in the video), so check for simple errors first. If you're able to get it to work when within an Excel file, but you find the CSV file does not contain the correct values, then before saving to CSV, copy the final column of names into a new column, but use "paste special" to paste the values only. Then you're guaranteed that the values will be in the CSV file (because they will no longer be based on an Excel formula). Finally, consider checking out my other video, where I offer a solution to the "last name first name" problem using flash fill, which is awesome, kzitem.info/news/bejne/06idza6mmoeTam0
@parladecreativeminds7431
3 жыл бұрын
Great video! How would I use the =CONCAT to automatically add once a new name is added on a new row. I tried to use the drag box down extra blank rows but it fills in a comma and space. Also I want to use that information to populate a drop down box in a form. Do you know how I'd be able to do that without those commas appearing.
@FrankMLoSchiavo
3 жыл бұрын
Good questions, although unfortunately I don't have time right now to look into the answers because my classes are starting soon and I need to focus on them. That said, I strongly recommend joining a few facebook groups that focus on Excel. Many of those members are Excel gurus, and they are eager to find solutions to people's problems. Good luck!
@TremainSr
6 ай бұрын
Can you help with MI between First and Last name?
@FrankMLoSchiavo
6 ай бұрын
Try using flash fill instead. I have a video about it: kzitem.info/news/bejne/06idza6mmoeTam0
@MyLife3636
4 ай бұрын
@@FrankMLoSchiavo Thanks!
@FrankMLoSchiavo
4 ай бұрын
@@MyLife3636 You're welcome :)
@briederilo4442
3 жыл бұрын
How about with middle name?
@FrankMLoSchiavo
3 жыл бұрын
I'd recommend using Flash Fill. Check out my follow-up video that shows how to convert last/first names using that strategy. FLASH FILL is like magic! You'll find that video here: kzitem.info/news/bejne/06idza6mmoeTam0
@VanessaDiazNYC
Жыл бұрын
thank you!!!!!!!!!!
@FrankMLoSchiavo
Жыл бұрын
You're welcome! By the way, I have a video that presents a second (easier) solution to that same problem. If interested, take a look, kzitem.info/news/bejne/06idza6mmoeTam0
@Brimstone69
9 ай бұрын
How to not seperate first name who have two names when seperating first name, middle name, and last name?
@FrankMLoSchiavo
9 ай бұрын
I posted a similar video with a second solution that uses flash fill. I recommend trying that. Here's the video: kzitem.info/news/bejne/06idza6mmoeTam0
@humaidiasnaf7191
2 жыл бұрын
sangat membantu, terima kasih
@FrankMLoSchiavo
2 жыл бұрын
You're welcome!
@John_GGG
2 жыл бұрын
Frank, you just saved me a lot of aggravation, a lot.
@John_GGG
2 жыл бұрын
And it worked. Thank you!!!!
@FrankMLoSchiavo
2 жыл бұрын
@@John_GGG You're welcome! Thx for letting me know :)
@JoeyR9
4 ай бұрын
Extremely helpful, thank you!
@FrankMLoSchiavo
4 ай бұрын
Glad the video helped! Thx for posting :)
@DiegoguerraCocc
4 жыл бұрын
OMG thx a lot!
@FrankMLoSchiavo
4 жыл бұрын
My pleasure!
@anuradhapanchal1267
Жыл бұрын
Sir I have some data in one cell like Kumar ,vijay,Singh how we write data in correct form in one cell
@FrankMLoSchiavo
Жыл бұрын
Hi. If you're trying to remove extra spaces, consider using the TRIM function. If you're trying to change the case of the text, try using the UPPER, LOWER, or PROPER functions. You also might want to ask Google or ChatGPT and see if they can provide other suggestions. Good luck :)
@lenyasis6870
4 жыл бұрын
hi, how could it work if there are 2 or more first names? please help...
@FrankMLoSchiavo
4 жыл бұрын
I'm sure there are many complicated ways to handle it with one Excel formula, but off the top of my head, I'd probably create one formula based on 1 first name, another based on 2 first names, etc., and then sort and apply the appropriate formula to each name. Once you have formulas written for 2 first names, etc., you could easily nest the formulas into one formula using the IF command. So, IF only 1 first name, apply the first formula, IF 2 first names, apply the second formula, etc. I hope this helps. If you develop a better solution, let me know.
@igotjoy1
3 жыл бұрын
Thank you for such a clear explanation! Much appreciated!
@FrankMLoSchiavo
3 жыл бұрын
My pleasure. Thx for commenting!
@aaronbrionesisme
2 жыл бұрын
I’m just curious how many “,” do we need to put before we put the fist name? Does that depend on the letters of the first name
@FrankMLoSchiavo
2 жыл бұрын
Below is the function/formula I used in the video. It can be written slightly more efficiently with a few tweaks, but in the video I wanted to take things one step at a time for clarity. =CONCAT(C2,","," ",B2)
@noleenangelafashion722
2 жыл бұрын
It can also work for windows10? Tia,
@keithjones8172
3 жыл бұрын
Thank you Frank. That's what I needed to know.
@FrankMLoSchiavo
3 жыл бұрын
Happy to help!
@rsm307studios
Жыл бұрын
OH MY GOSH!!! This is something that has frustrated me for YEARS!!! So many different Divisions inside our City Government list their employees in Excel as First Name, Last Name, others just first name or just last name, when all I really want is LAST NAME, FIRST NAME. Where have you been all my life? I "used to" consider myself very experienced in Excel. Well, today you proved me wrong. Thanks again!!!
@FrankMLoSchiavo
Жыл бұрын
I'm so glad the video helped you! Please spread the love by sharing the video with everyone you know, lol!
@akshaykumartamboli578
3 жыл бұрын
Thanks ☺️
@FrankMLoSchiavo
3 жыл бұрын
You're welcome.
@liezlresurrecion2587
Жыл бұрын
Thank you
@FrankMLoSchiavo
Жыл бұрын
You're welcome :)
@charlescavan911
2 жыл бұрын
Thank you 😊
@FrankMLoSchiavo
2 жыл бұрын
My pleasure. Be sure to watch my video with another solution to that same problem. It uses flash fill, which is really easy.
@monicamusaraca972
3 жыл бұрын
Omg you just saved my life!😁
@FrankMLoSchiavo
3 жыл бұрын
My new video addresses that same problem but fixes it ever faster! Check it out: kzitem.info/news/bejne/06idza6mmoeTam0
@monicamusaraca972
3 жыл бұрын
@@FrankMLoSchiavo holy crap, i love it! It works 😃 I feel like I just won the lottery lol
@monicamusaraca972
3 жыл бұрын
Thank you!!
@monicamusaraca972
3 жыл бұрын
@@FrankMLoSchiavo Actually I have one more problem I have a list of names next to it I have a date of birth and next to that I have the location of a facility they need to go to for medical... My initial problem whoz that the names needed to be last name 1st with a, in between like you addressed.. The problem is I had started by hand with about 2:00 of the 6:00 rose so some of them already were done... And they are intermingled... And they are intermingled Is there a way to do it still so it only picks the ones that are not finished yet?
@monicamusaraca972
3 жыл бұрын
Sorry, typos, talk texting. *200 and *600
@TheDilbertdave
22 күн бұрын
Great tip! And very well presented. Exactly what I needed to know. Thank you so much!
@FrankMLoSchiavo
22 күн бұрын
You're welcome! Glad it helped :)
@Mmaarrzz
Жыл бұрын
Thank you thank you ! I have no idea what I’m doing at my new job but I’m learning, from you ! Much appreciated
@FrankMLoSchiavo
Жыл бұрын
I'm glad the video helped you. Good luck with your new job!
Пікірлер: 118