Name Order

cr8success · May 19th, 2002, 09:49 PM

How can I change the following in Excel Field

Smith, John to John Smith AND
Field called First Name
Field called Last Name
Split the Name so that John is in First Name
and Smith is in Field Last Name

RichardS · May 19th, 2002, 09:56 PM

If your data is in the format you have indicated, highlight the data and use text to columns, with a comma as the delimiter. Then you can just cut the first name column and insert the cut cells beofre the surname.
HTH
Richard

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 19th, 2002, 09:49 PM	#1
cr8success New Member Join Date: May 2002 Posts: 1	How can I change the following in Excel Field Smith, John to John Smith AND Field called First Name Field called Last Name Split the Name so that John is in First Name and Smith is in Field Last Name

May 19th, 2002, 09:56 PM	#2
RichardS Board Regular Join Date: Feb 2002 Location: Victoria, Australia Posts: 761	If your data is in the format you have indicated, highlight the data and use text to columns, with a comma as the delimiter. Then you can just cut the first name column and insert the cut cells beofre the surname. HTH Richard