Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I merge two cells without deleting data from the cell? | Excel Discussion (Misc queries) | |||
How to combine 2 cells' data into 1 cell? | Charts and Charting in Excel | |||
Splitting Data in a Cell | Excel Worksheet Functions | |||
I want to split containt of a cell and copy in seprate cells | Excel Worksheet Functions | |||
Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) |