Get instant live expert help on I need help with excel separate first and last name

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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 23 mins
Hi, I need a formula that will separate a text string into two cells. The opposite of concat. For example: Last name, First name (cell1A) into Last name (cell 2A) and first name (cell 3A). Thank you,
Solved by K. L. in 14 mins
I need to separate a cell into first name last name and email but using "text to columns" is not working
Solved by S. F. in 29 mins
Could anyone help me to create a function that will separate the First name, Middle Initial and last name with this format "BALDONASA, JENNIFER T."
Solved by F. A. in 30 mins
How do I combine a column FIRST NAME with the next column LAST NAME to produce a column = FIRST NAME LAST NAME? I am submitting a list to a print shop and my list is in Excel by First Name, Last Name, Address, City, State, Zip. The print shop requires First Name Last Name and then the other fields. Help?
Solved by S. H. in 26 mins