# Excel - COLUMN Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.