Welcome to WebmasterWorld Guest from 54.144.15.10

Forum Moderators: bill

Message Too Old, No Replies

Need a tricky Excel formula.

excel formula if

     
11:24 pm on Aug 24, 2007 (gmt 0)

New User

5+ Year Member

joined:Aug 24, 2007
posts:1
votes: 0


I'm hoping this is possible..

What I have is a name column like this:

ANTHONY D DE ROSE
EDUARDA J DE SOSA
EMANUEL O DE SOUSA
EMANUEL O DE SOUSA
JOSHUA W DEAN
DALE A DEBRUIN
JAMES F DEDIEGO
ROBERT COOLIDGE

And I need to end up with two columns; a FIRSTNAME and LASTNAME. (FIRSTNAME containing any middle initial and LASTNAME containing any two-part last name such as 'De Rose', etc).

Any ideas?

8:11 am on Aug 26, 2007 (gmt 0)

Administrator from JP 

WebmasterWorld Administrator bill is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Oct 12, 2000
posts:14793
votes: 87


Welcome to WebmasterWorld nakiannu.

Try a search for Excel & separate names into individual columns [google.com].

hat tip to jessejump for the keywords