excel firstnames & lastnames

  jaraba 16:37 23 Jul 08
Locked

I have spreadsheets with firstnames & lastnames in one coloumn & would like to convert them to separte coloumns.
Anyone know a formula to do it.

  nosharpe 17:04 23 Jul 08

Assuming the first name appears in A1
In B1, type =LEFT(A1,FIND(" ",A1)) to produce the first name
In C1, type =MID(A1,FIND(" ",A1)+1,20) to produce the last name

  jaraba 18:21 23 Jul 08

nosharpe
Tried that & worked ok on 1st line.
When copied down showed results from 1st line in subsequent rows.

  jaraba 18:24 23 Jul 08

nosharpe
Found the error
Had automatic calculation turned off.

  jaraba 18:28 23 Jul 08

Sorry
So pleased at finding answer to the error forgot to say
A Big Thank You

  VoG II 15:41 24 Jul 08

Without a formula: make sure there is a blank column to the right of your column of names. Select your column of names > Data > Text to Columns, select Delimited and specify Space as the delimiter then press Finish.

  VoG II 15:44 24 Jul 08

Alternative formulas

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

(this avoids a trailing space)

C1 =RIGHT(A1,LEN(A1)-FIND(" ",A1))

This thread is now locked and can not be replied to.

What is ransomware and how do I protect my PC from WannaCry?

What I learned from my mentor, Oscar-winning VFX supervisor Phil Tippett

Siri vs Google Assistant