how do i separate 2 strings of a cell in different cells?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have names and surnames both in a single cell?
I want to separate them in different cells.
 
Assuming names separated by a blank only one forename plus surname):


=TRIM(LEFT(A1,FIND(" ",A1)-1))


=TRIM(MID(A1,FIND(" ",A1)+1,255))

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split Alpha Field 2
Formula Help 0
Trim a cell that has names and address to only show name 8
Sorting 2 names in one column 3
Extracting Address data from single cells 2
name separation 3
Splitting Names 6
Separating data in the same cell 1

Back
Top