homepage Welcome to WebmasterWorld Guest from 50.16.173.192
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Microsoft / Microsoft Windows OS (XP/NT/Vista/Windows 7/8/9/10)
Forum Library, Charter, Moderators: bill

Microsoft Windows OS (XP/NT/Vista/Windows 7/8/9/10) Forum

    
Need a tricky Excel formula.
excel formula if
nakiannu

5+ Year Member



 
Msg#: 3431633 posted 11:24 pm on Aug 24, 2007 (gmt 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?

 

bill

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



 
Msg#: 3431633 posted 8:11 am on Aug 26, 2007 (gmt 0)

Welcome to WebmasterWorld nakiannu.

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

hat tip to jessejump for the keywords

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Microsoft / Microsoft Windows OS (XP/NT/Vista/Windows 7/8/9/10)
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved