Posted to microsoft.public.excel.programming

JasonK[_3_] JasonK[_3_] is offline

external usenet poster

Posts: 38

creating last name first, first name last from a column of first name last name data

thank you -- worked perfectly
jasonK

On Mon, 27 Jul 2009 02:25:08 -0400, "Rick Rothstein"
wrote:

Give this formula a try...

=MID(A2&", "&A2,FIND(" ",A2)+1,LEN(A2)+1)

Change the A2 to the cell address of the cell containing your first set of
names and then copy it down.

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
creating mutilple columns from one column of data	Tracy	Excel Discussion (Misc queries)	3	February 4th 09 10:46 AM
Creating reference numbers from column of data	LucasD	Excel Worksheet Functions	3	September 25th 08 03:23 PM
Creating directories from given column of data	Kelly[_9_]	Excel Programming	6	January 18th 08 09:42 PM
Creating a column with just data before comma in another column	Help with text manipulation	Excel Worksheet Functions	2	November 18th 07 06:18 PM
creating a date column from seperate data	T.O.	Excel Worksheet Functions	3	December 20th 05 01:22 PM

All times are GMT +1. The time now is 09:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us