Very helpful video. I was wondering about changing the names to values as I ran into this problem before I finished watching the video. Thank you so much!
OMG, Thank you verrryyyy muuucchh. Your video really helped me. Just like Kyle said, You just saved me hours of work, cuz I've been recording scanned attendance of almost 500 students😭
Great to hear! Let me know if you have any other "data cleaning" issues when exporting your HR/Payroll data from ADP. I'm slways looking for ideas for more videos that folks will find useful. Thanks for watching!
I viewed this video, even though I had learned how to do this previously, in order to refresh myself. Also after viewing other videos of yours I was curious as to how you would present this topic. My intial impressions were correct, your videos are among the much better ones available! I'm just surprised at the number of likes; I feel the number should be much, much higher! Also, you covered an aspect I didn't know, how to swap from full name with last name first to full name with first name first! Learn something new every day! Thanks for doing such an exemplary job and making such great video tutorials!
Thank you so much for sharing this. I have a question that I believe many others also have. From a column with the full name of first name 2 or 3 middle names and last name. How could you separate only the first name in one column and the rest of the name in another column? Thanks in advance for your time
Hello, assuming your formatting has a space between first and other names in the cell, you can use the Text to Columns feature to extract the first name into a different column/cell. 1. Select the column that contains the full names and insert a new blank column next to it. 2. Go to the Data tab in the Excel ribbon. 3. Click on Text to Columns in the Data Tools group. 4. In the Convert Text to Columns Wizard, select Delimited and click Next. 5. Check the box next to Space and uncheck all other boxes. You should see a preview of how the text will be separated in the Data preview section. Click Next. 6. In the third step of the wizard, you can specify the data format for each column if needed. For this case, you can leave everything as General and click Finish. You should now have two new columns: one with the first names and another with the rest of the names. Hope this helps! Thanks for watching my videos!
Thank you Sharon for this video. I do have a question, whenever I do this instead of having a single space between the first and last name, it always ends up being around 30 spaces between the names. Anyone know why this is happening and how to correct? Thanks.
I'm not sure why that is happening, but if you have a cell formatted with text and too many spaces between first and last name, you can insert a new blank column next to the name column and use the TRIM formula. Click in a cell and type: =TRIM(A2) if A2 were the cell that had the name with too many spaces. TRIM will eliminate all the extra spaces. Hope this helps! Thanks for watching!
Can you clarify what you are trying to do? You can create text manipulation functions in Excel to handle this. Are you trying to update John & Jane Doe to "Doe, John & Jane?" or split them out? Thanks for watching!
how do you make this a "running" function? you copied and pasted the names, but what if you regularly add names to the list, and want this function to happen as you add the names?
Hi Ryan! Select the column in your spreadsheet that has the space+name. On the Home tab, in the Editing area, drop-down "Find & Select" and select "Replace." This opens the Find & Replace pop-up window where you can select the "Replace" tab, and in the field for "Find what:" place your cursor there and hit one space. Leave the "Replace with:" field blank and then click "Replace All." This will remove that space in the column or cell you selected. Hope this helps! Thanks for watching!
You need to also check off the space with the comma when selecting your delimiter, otherwise you end up with a space in front of the name, as she did in this example. 😀
This is a fantastic video that saved me about 4 hours of work and a ton of error avoided! You ROCK!
Awesome! That is great to hear. Thanks for watching!
THANK YOU! IVE LEARNED SOME THING AGAIN.
Glad to hear it. Thanks for watching!
LIFE SAVER. Thank you Sharon!
Glad to help! Thanks for watching!
Excellent Presentation. For someone who has no eperience in Excel you made very easy.
I'm so glad to hear that! I hope you are learning a lot from my videos. Thanks for watching!
Very helpful video. I was wondering about changing the names to values as I ran into this problem before I finished watching the video. Thank you so much!
Glad to hear my video helped you out! Thanks for watching!
Thank you! You are a fantastic instructor. And I don't say that lightly. You are now my go-to source when I need help with Excel.
That is great to hear! I’m glad you find my videos helpful! Thanks for watching!
OMG, Thank you verrryyyy muuucchh. Your video really helped me. Just like Kyle said, You just saved me hours of work, cuz I've been recording scanned attendance of almost 500 students😭
I’m so glad to hear my video helped save you valuable time! Thanks for talking time to leave a nice comment. I appreciate it!
a fantastic instructional video, just saved me a ton of grief and frustration!
So glad to hear it! Thanks for watching and for subscribing to my Channel!
Thank you so much. Saved our team a lot of work!
That is great to hear, Latasha! Glad you all found it helpful! Thanks for watching!
OMG THIS HAS SAVED SOOOOO MUCH TIME FOR ME!!!! THANK YOU! (yes all caps because I am super excited)
I'm so glad that my video helped you!!! Thanks for watching!
Love you, for this!!!! Thank you!
Glad you found it helpful! Thanks for watching!
This serious just saved me about an hour worth or work! Thank you.
So glad to hear you found it helpful and it saved you time! Thanks for watching!
This was exactly want I wanted to learn. Thank you Sharon Smith
Great to hear, Tammy! Thanks for watching!
You just saved me hours of work! Easy to follow and very helpful. Thank you!!!
Awesome! Glad to hear that! Thanks for watching my videos, Kyle!
Awesome video, Sharon. This helps so much. Especially when exporting data from ADP!
Great to hear! Let me know if you have any other "data cleaning" issues when exporting your HR/Payroll data from ADP. I'm slways looking for ideas for more videos that folks will find useful. Thanks for watching!
I viewed this video, even though I had learned how to do this previously, in order to refresh myself. Also after viewing other videos of yours I was curious as to how you would present this topic. My intial impressions were correct, your videos are among the much better ones available! I'm just surprised at the number of likes; I feel the number should be much, much higher! Also, you covered an aspect I didn't know, how to swap from full name with last name first to full name with first name first! Learn something new every day! Thanks for doing such an exemplary job and making such great video tutorials!
Thank you so much! I'm glad you got something new out of this video. I really appreciate your support and I'm glad you found my channel!
Thank you so much for the donation to my Channel! It is greatly appreciated!
Your video saved me from my perfectionist friend hahaha thank you so much
Haha! Glad to help! Thanks for watching!
Thank you! Very simple and very helpful
Glad you found it helpful! Thanks for watching!
excellent saved me soooo much time
So glad you found my videos helpful, Victoria! Thanks for watching and for subscribing to my Channel!
Thank you - been looking for this fr 20 mins! :)
Glad you found my video! Thanks for watching!
You just saved my butt at work thank you so much,
Awesome! Glad to hear my video helped you out at work. Thanks so much for watching!
Awesome! Thanks for the help
Glad to help! Thanks for watching!
This is so helpful!
Glad you found it helpful ;-) Thanks for watching!
Thank you for this tutorial!
Glad you found it helpful! Thanks for watching!
Thanks so much!
Thank you for watching!
Life saver. Thanks
I'm happy to help! Thanks so much for watching my videos!
This is so clear and helpful. Thank you.
Glad you found it helpful!! Thanks for watching my videos!
Thank you so much for sharing this. I have a question that I believe many others also have. From a column with the full name of first name 2 or 3 middle names and last name. How could you separate only the first name in one column and the rest of the name in another column? Thanks in advance for your time
Hello, assuming your formatting has a space between first and other names in the cell, you can use the Text to Columns feature to extract the first name into a different column/cell.
1. Select the column that contains the full names and insert a new blank column next to it.
2. Go to the Data tab in the Excel ribbon.
3. Click on Text to Columns in the Data Tools group.
4. In the Convert Text to Columns Wizard, select Delimited and click Next.
5. Check the box next to Space and uncheck all other boxes. You should see a preview of how the text will be separated in the Data preview section. Click Next.
6. In the third step of the wizard, you can specify the data format for each column if needed. For this case, you can leave everything as General and click Finish.
You should now have two new columns: one with the first names and another with the rest of the names.
Hope this helps! Thanks for watching my videos!
Thank you!!
Glad to help! Thanks for watching!
Lovely ❤ thanks so much for the help ma'am ❤
Glad to help! Thanks for watching!
It helps me a lot
Glad to help! Thanks for watching!
Informative...very helpful my work
Glad you found it helpful! Thanks for watching!
Thank you Sharon for this video. I do have a question, whenever I do this instead of having a single space between the first and last name, it always ends up being around 30 spaces between the names. Anyone know why this is happening and how to correct? Thanks.
I'm not sure why that is happening, but if you have a cell formatted with text and too many spaces between first and last name, you can insert a new blank column next to the name column and use the TRIM formula. Click in a cell and type: =TRIM(A2) if A2 were the cell that had the name with too many spaces. TRIM will eliminate all the extra spaces. Hope this helps! Thanks for watching!
@@SharonSmith THAT WORKED!!! THANK YOU!!!
Thank you, but how do you insert the coma to separate the first and last name?
Add the coma between the two quotes.
I copied about 25 names from my word document to Excell. How do I make the row into a column. Transpose is not working. All names are in one cell.
very helpful
Glad to help! Thanks for watching!
Thank you so much
You are very welcome! I appreciate you watching my videos.
What if I have a list that has John & Jane Doe or John Doe & Jane Doe. Is there a way to do that?
Can you clarify what you are trying to do? You can create text manipulation functions in Excel to handle this. Are you trying to update John & Jane Doe to "Doe, John & Jane?" or split them out? Thanks for watching!
tHANK YOU
You are very welcome! Thanks for watching!
Thank you🙏
You are very welcome!! Thanks for watching!
Can I create a first last name column from a last first list no comma column?
Very useful
Glad you found it helpful! Thanks for watching!
Thank You
You are very welcome! Thanks for watching!
how do you make this a "running" function? you copied and pasted the names, but what if you regularly add names to the list, and want this function to happen as you add the names?
Thanks
Thanks for watching, Ramesh!
Now there is a space in front of the first name. How do I get rid of that?
Hi Ryan! Select the column in your spreadsheet that has the space+name. On the Home tab, in the Editing area, drop-down "Find & Select" and select "Replace." This opens the Find & Replace pop-up window where you can select the "Replace" tab, and in the field for "Find what:" place your cursor there and hit one space. Leave the "Replace with:" field blank and then click "Replace All." This will remove that space in the column or cell you selected. Hope this helps! Thanks for watching!
How do you add the comma after you've switched it over
You'd replace the " " with a , so =(cell)&,&(cell)
Nice
Thanks for watching!!
You need to also check off the space with the comma when selecting your delimiter, otherwise you end up with a space in front of the name, as she did in this example.
😀
good stuff but you noticed there is a single space before the first name
very helpful
Glad you found it helpful, Jack! Thanks for watching!
Thanks
Thanks for watching!!