excel firstnames & lastnames

  jaraba 16:37 23 Jul 2008

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 2008

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 2008

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

  jaraba 18:24 23 Jul 2008

Found the error
Had automatic calculation turned off.

  jaraba 18:28 23 Jul 2008

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

  VoG II 15:41 24 Jul 2008

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 2008

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.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017