Get instant live expert help on I need help with excel formula to 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

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
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
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
Need formula to separate first last names in one cell and create two cells with first name in one and last in the second... and I need a formula to take a name like "Mike and Pam Smith" and create a new cell with "Mr. and Mrs. Smith"
Solved by C. U. in 17 mins
I need a formula to add the date of on column K to the end of the text on column B and the surname, first name, and last name on the front of column B. Also I need help with formula to separate the First name, Last name, an address from column A to the corresponding columns on the sheet
Solved by A. F. in 29 mins