How to separate fname and fname in cell in excel

Posted to microsoft.public.excel.programming

Excel Problem Excel Problem is offline

external usenet poster

Posts: 5

How to separate fname and fname in cell in excel

Can soneone help me to wright a formula that will separate lname and fname in cell "B" to Cell"A "=lname and cell"B"=fname. Thy are separate by comma and space in cell "B" in excel 2000.
My e-mail address is

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
Create user id fm LName, FName	sjs	Excel Worksheet Functions	3	July 1st 08 08:26 PM
multiple file uploading - runtime error'13': type mismatch "While Counter <= UBound(FName)"	Sinner	Excel Discussion (Misc queries)	3	March 1st 07 09:44 AM
change lname, fname to fname last name	Al Wills	Excel Discussion (Misc queries)	4	June 6th 05 06:18 AM
how do i reference data in a file with the fname in another cell?	jhlrtn	Excel Worksheet Functions	1	May 23rd 05 11:11 PM
Separate first and second name in one cell into separate cells.	Gary's Student	Excel Discussion (Misc queries)	0	April 27th 05 11:11 PM

All times are GMT +1. The time now is 10:41 AM.

Menu

About Us