Posted to microsoft.public.excel.worksheet.functions

Mervyn Thomas[_2_] Mervyn Thomas[_2_] is offline

external usenet poster

Posts: 19

Extracting firstname and secondname with functions

Does anyone have functions which will extract "firstname" and "secondname"
into seperate cells from a cell containing "firstname secondname" ?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is there a way to separate FirstName and LastName ?	Mark246	Excel Discussion (Misc queries)	4	February 24th 08 01:42 AM
LastName, FirstName covert to FirstName LastName	Craig860	Excel Discussion (Misc queries)	4	January 14th 08 09:58 PM
How to change lastname, firstname to firstname lastname in Excel?	mert	Excel Discussion (Misc queries)	1	January 9th 08 06:06 PM
Splitting firstName from Surname	Althea	Excel Worksheet Functions	5	April 23rd 06 09:05 PM
Extracting data without using database functions	MelbTim	Excel Worksheet Functions	5	May 30th 05 06:20 AM

All times are GMT +1. The time now is 10:23 PM.

About Us

"It's about Microsoft Excel"