Question description:
This user has given permission to use the problem statement for this
blog.
I have a list of names. They are all in 1 column. I would like to split up the first and last names into 2 columns without having to do each name individually.
Solved by X. S. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
10/05/2018 - 03:02
Hello
Excelchat Expert
10/05/2018 - 03:02
Welcome to got it pro
User
10/05/2018 - 03:02
Hi
User
10/05/2018 - 03:03
Thanks
Excelchat Expert
10/05/2018 - 03:03
You want to split first and last names, right?
User
10/05/2018 - 03:03
Yes
User
10/05/2018 - 03:03
They are in column A and I want them split between 2 columns
Excelchat Expert
10/05/2018 - 03:04
I need to see a few samples in order to write a formula, can you show me some?
Excelchat Expert
10/05/2018 - 03:04
understood
User
10/05/2018 - 03:05
Don't know if there is a way to split between spaces?
Excelchat Expert
10/05/2018 - 03:05
Yes there is.
Excelchat Expert
10/05/2018 - 03:06
If your names are separated by spaces, then =LEFT(A1,SEARCH(" ",A1)) will give you first name.
Excelchat Expert
10/05/2018 - 03:07
And =RIGHT(A1,LEN(A1)-SEARCH(" ",A1)) will give you last name.
Excelchat Expert
10/05/2018 - 03:07
Makes sense?
User
10/05/2018 - 03:08
Yes that makes sense, but how do I do it for a list of 700 names?
User
10/05/2018 - 03:08
because that splits the name in A1 only
Excelchat Expert
10/05/2018 - 03:09
When you select a cell, do you see a tiny square box at the bottom right corner of the cell?
User
10/05/2018 - 03:10
yes I see that
Excelchat Expert
10/05/2018 - 03:10
It is called fill handle. Double clicking on that box will copy the formula down for the rest of the column.
Excelchat Expert
10/05/2018 - 03:11
Need further help?
User
10/05/2018 - 03:11
that worked!
Excelchat Expert
10/05/2018 - 03:11
Yay!!!!!!!!!!!
User
10/05/2018 - 03:11
I never knew that feature
Excelchat Expert
10/05/2018 - 03:11
Its pretty handy, right?
User
10/05/2018 - 03:11
thanks so much!
Excelchat Expert
10/05/2018 - 03:12
Glad to be able to help.
User
10/05/2018 - 03:12
Very handy!
User
10/05/2018 - 03:12
that works for any equation?
Excelchat Expert
10/05/2018 - 03:12
If you think I deserve a 5 star, please rate me 5 star.
User
10/05/2018 - 03:12
I will!
Excelchat Expert
10/05/2018 - 03:12
Yes, it works in every equation.
User
10/05/2018 - 03:13
Thanks again, you saved me lots of time!
Excelchat Expert
10/05/2018 - 03:13
Thank you too for trying out got it pro
Excelchat Expert
10/05/2018 - 03:13
Have a great day ahead!
User
10/05/2018 - 03:13
you too
Excelchat Expert
10/05/2018 - 03:14
A note, please close the session now. I believe there is a close button on hour side.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.