Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Michele
 
Posts: n/a
Default Split data from one cell to two separate cells

How do you take "Smith, John" from one cell and create one cell with "Smith"
and another with "John"? Basically, the reverse of Concatenation.
  #2   Report Post  
Zack Barresse
 
Posts: n/a
Default Split data from one cell to two separate cells

Hi there,

Assuming it's in A1

Last:
=LEFT(A1,FIND(",",A1,1)-1)

First:
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))

If that is all the permutations you'll have, then you should be set. If you
happen to have any other names, middle initials, suffixes, then you'll need
another approach. Chip Pearson lines it out very well on his site here ...

http://www.cpearson.com/excel/FirstLast.htm

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.



"Michele" wrote in message
...
How do you take "Smith, John" from one cell and create one cell with
"Smith"
and another with "John"? Basically, the reverse of Concatenation.



  #3   Report Post  
Graham Haughs
 
Posts: n/a
Default Split data from one cell to two separate cells

Hi Micelle,
If in A1 then select this cell then you should also try out
the Data Text to Columns then follow instructions.

Regards
Graham Haughs

Michele wrote:
How do you take "Smith, John" from one cell and create one cell with "Smith"
and another with "John"? Basically, the reverse of Concatenation.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do I merge two cells without deleting data from the cell? Batmans_Wife Excel Discussion (Misc queries) 50 April 3rd 23 10:54 AM
How to combine 2 cells' data into 1 cell? [email protected] Charts and Charting in Excel 1 October 12th 05 02:54 AM
Splitting Data in a Cell Newbie1092 Excel Worksheet Functions 3 May 10th 05 05:48 PM
I want to split containt of a cell and copy in seprate cells Sima Excel Worksheet Functions 2 May 9th 05 07:46 PM
Combining data (numeric format) in multiple cells into one cell (t GNAC SID Excel Discussion (Misc queries) 2 February 7th 05 05:09 PM


All times are GMT +1. The time now is 08:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"