How to Separate Names in Microsoft Excel - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 8
Pat
This was a great trick. May I ask how you would do the same thing for Middle Initials (or Names) when not every full name had a middle initial or name? I tried using the same concept as you explained but it didn't work very good. My column A or Full Name is LastName, FirstName MiddleInitial(.). So for example, Jones, Brad P. would be in the full name column. With your method, any full name that didn't have a middle initial, their first name would be put in for a Middle Initial. So I had to delete those first names to make the columns correct. This is fine for 10 or so names, but if there is a long list of full names, what could I do to get the correct outcome.
Thanks!!!!
reply
This was a great trick. May I ask how you would do the same thing for Middle Initials (or Names) when not every full name had a middle initial or name? I tried using the same concept as you explained but it didn't work very good. My column A or Full Name is LastName, FirstName MiddleInitial(.). So for example, Jones, Brad P. would be in the full name column. With your method, any full name that didn't have a middle initial, their first name would be put in for a Middle Initial. So I had to delete those first names to make the columns correct. This is fine for 10 or so names, but if there is a long list of full names, what could I do to get the correct outcome.
Thanks!!!!
reply
ven
Hi good day! I don't have a business, I just bought myself a Laptop to learn how to use it with the Internet, I find your videos very Interested and I'm learning a lot so far from U! I would really like to know how to use Power point, Excel and Microsoft Word to do some Online business like helping person with Valuable Contents, Create YouTube Thumbnail and design Things! Thanks much!!
reply
Hi good day! I don't have a business, I just bought myself a Laptop to learn how to use it with the Internet, I find your videos very Interested and I'm learning a lot so far from U! I would really like to know how to use Power point, Excel and Microsoft Word to do some Online business like helping person with Valuable Contents, Create YouTube Thumbnail and design Things! Thanks much!!
reply
deepanshusood
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
reply
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
reply
Linda
Gosh, you are so amazing! I often go to your videos to learn all your helpful tricks for excel. You sure save me a lot of time and make my work a lot easier. Even though you don't know me but You make me look good!
reply
Gosh, you are so amazing! I often go to your videos to learn all your helpful tricks for excel. You sure save me a lot of time and make my work a lot easier. Even though you don't know me but You make me look good!
reply
Balsero
Thank you very much for this video!! I have a question please, how can I separate the names if they have a minus symbol (-) in between? Example: John-Smith
Thank you so much!!
reply
Thank you very much for this video!! I have a question please, how can I separate the names if they have a minus symbol (-) in between? Example: John-Smith
Thank you so much!!
reply
Frank
This was very helpful, but recently there's a lot of people with two last names. For example, Johnson-Smith or Anderson-Stratvert. It will only pick up the last part of that name.
reply
This was very helpful, but recently there's a lot of people with two last names. For example, Johnson-Smith or Anderson-Stratvert. It will only pick up the last part of that name.
reply
Xia
How about if the First Name has a Second name for example Reyes, Mary Jane Sanchez how will it separate? the first name that has Second Name (Mary Jane). Thank you.
reply
How about if the First Name has a Second name for example Reyes, Mary Jane Sanchez how will it separate? the first name that has Second Name (Mary Jane). Thank you.
reply
Monika
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?
reply
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?
reply
Add a review, comment
Other channel videos
