Question description:
This user has given permission to use the problem statement for this
blog.
I have full names in one column and would like to have the first name in a then the last name in b
Solved by I. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
12/06/2018 - 03:54
Hi
Excelchat Expert
12/06/2018 - 03:54
Welcome to Got it Pro
Excelchat Expert
12/06/2018 - 03:55
Please paste the sample data so that i can help you better
User
12/06/2018 - 03:55
Hi
User
12/06/2018 - 03:56
do you see it?
Excelchat Expert
12/06/2018 - 03:56
yes
Excelchat Expert
12/06/2018 - 03:57
See A6
Excelchat Expert
12/06/2018 - 03:57
Do you see?
User
12/06/2018 - 03:57
yes
Excelchat Expert
12/06/2018 - 03:58
ALso see B6
Excelchat Expert
12/06/2018 - 03:58
Does that help you ?
Excelchat Expert
12/06/2018 - 03:58
Are you there?
Excelchat Expert
12/06/2018 - 03:59
Please let me know
User
12/06/2018 - 03:59
No how did you split them see a 1
Excelchat Expert
12/06/2018 - 03:59
Yes i see
Excelchat Expert
12/06/2018 - 03:59
You want mary smith to be split in Mary and Smith
User
12/06/2018 - 04:00
yes
Excelchat Expert
12/06/2018 - 04:00
I have done the same in A6 and B6
Excelchat Expert
12/06/2018 - 04:00
Please see the formula
User
12/06/2018 - 04:00
I have over 100 names to split
Excelchat Expert
12/06/2018 - 04:01
Write those names below mary smoth
Excelchat Expert
12/06/2018 - 04:01
Smith*
Excelchat Expert
12/06/2018 - 04:01
and drag the formula in column B and C
Excelchat Expert
12/06/2018 - 04:02
See row 2..it is working fine
Excelchat Expert
12/06/2018 - 04:04
Are you there?
Excelchat Expert
12/06/2018 - 04:04
Please let me know if this helps
Excelchat Expert
12/06/2018 - 04:05
Please do give good rating and reviews
Excelchat Expert
12/06/2018 - 04:05
It really helps
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.
