Excel - Formula

[cheech25]

Will somone please help me with a fomula to separate a first name from last name in a column? Thank you for your help.

Thank You

 

[AnotherHiggins]

What is the current format? We can't read your mind, you know.

LastName, FirstName?
FirstName LastName?

Give us something to work with.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[cheech25]

A:FullName B:LastName C:FirstName


Sorry about that. Thank you.

Thank You

 

[GlennUK]

There are many things to consider ... Chip Pearson has had a fairly good go at this:

http://www.cpearson.com/excel/FirstLast.htm

although I don't know if even his stuff could cope with names like
jean marie le pen
richard van der groot


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[cheech25]

I tried the first name formula from your attachment and it is pulling over the whole name. I have even tried to play arount with it.

I use this formula =LEFT(A1,FIND(" ",A1))to recognize a numer from a street address. Do you know of something like this I can use to recognize text?

Thank You

 

[AnotherHiggins]

That WILL recognize text. Have you tried that formula with your names?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[cheech25]

Got it Thank you.

Thank You