Question description:
This user has given permission to use the problem statement for this
blog.
in column a i have patients last name and first together and i want a separate column for last name and first name. is there away to do that or do i have to manually add the first name into a column
Solved by S. J. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
24/05/2018 - 02:49
Hello, I understand that you need help in separating the first name and last name, right?
User
24/05/2018 - 02:49
yes
User
24/05/2018 - 02:49
it is in one column
Excelchat Expert
24/05/2018 - 02:50
I see. Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question. We also currently do not support VBA/Macro solutions.
User
24/05/2018 - 02:50
ok
Excelchat Expert
24/05/2018 - 02:50
Okay, this is only possible if we can identify a pattern that works for ALL names.
User
24/05/2018 - 02:51
all names are last name, first name
Excelchat Expert
24/05/2018 - 02:51
It can't be a "maybe" pattern. It has to be a concrete rule like the first and last name are separated by a comma, or there's only 1 first name and 1 last name for all names etc.
Excelchat Expert
24/05/2018 - 02:51
Are you able to provide a few sample names so I can analyze them?
User
24/05/2018 - 02:51
its separated by a comma
Excelchat Expert
24/05/2018 - 02:51
If not, then you can just write dummy names.
User
24/05/2018 - 02:52
ABREU, SALEEMA
ABREU-HERNANDEZ, JASMINE
ACCETTA, JOSEPH
User
24/05/2018 - 02:52
ok
Excelchat Expert
24/05/2018 - 02:53
Can you type it in the sheet to the right?
Excelchat Expert
24/05/2018 - 02:53
Typing it here removes the formatting.
User
24/05/2018 - 02:53
ok done
Excelchat Expert
24/05/2018 - 02:53
Are you using Excel?
User
24/05/2018 - 02:53
yes
Excelchat Expert
24/05/2018 - 02:54
Okay, please open the file with the names listed.
Excelchat Expert
24/05/2018 - 02:54
Then highlight the entire column.
Excelchat Expert
24/05/2018 - 02:54
Then go to DATA then click Text to Columns.
Excelchat Expert
24/05/2018 - 02:54
Let me know once you are able to follow.
User
24/05/2018 - 02:55
done
Excelchat Expert
24/05/2018 - 02:56
Then select delimited then click Next.
Excelchat Expert
24/05/2018 - 02:56
Put a check in Comma then click finish
Excelchat Expert
24/05/2018 - 02:56
The first name and last name will now be placed in separate columns.
User
24/05/2018 - 02:57
wow thanks
Excelchat Expert
24/05/2018 - 02:57
All good on your end?
User
24/05/2018 - 02:58
yes
Excelchat Expert
24/05/2018 - 02:58
That's great!
User
24/05/2018 - 02:58
thank you
Excelchat Expert
24/05/2018 - 02:58
Glad to have helped!
Excelchat Expert
24/05/2018 - 02:58
Would there be anything else that I can help you with regards to the original question?.
User
24/05/2018 - 02:58
no I am good now thanks
Excelchat Expert
24/05/2018 - 02:59
Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating and your feedback if you think I deserve it.
Excelchat Expert
24/05/2018 - 02:59
I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of.
.
Excelchat Expert
24/05/2018 - 02:59
Please do not forget to click the End Session button otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.
User
24/05/2018 - 02:59
ok great will do
User
24/05/2018 - 02:59
thanks again
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.
