Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I transpose Comma Separated Data in each cell and delete t.
I need to switch a names list in each cell:
[LAST_NAME, FIRST_NAME] to [FIRST_NAME LAST_NAME] (no comma), preferably into two cells: [FIRST_NAME] [LAST_NAME] |
#2
|
|||
|
|||
Last Name:
=LEFT(A1,FIND(",",A1)-1) First Name: =MID(A1,FIND(",",A1)+2,999) HTH Jason Atlanta, GA -----Original Message----- I need to switch a names list in each cell: [LAST_NAME, FIRST_NAME] to [FIRST_NAME LAST_NAME] (no comma), preferably into two cells: [FIRST_NAME] [LAST_NAME] . |
#3
|
|||
|
|||
You may be able to just select the column of names and use DataText to
Columns. Specify Comma Delimited in first & second step |:) "randy" wrote: I need to switch a names list in each cell: [LAST_NAME, FIRST_NAME] to [FIRST_NAME LAST_NAME] (no comma), preferably into two cells: [FIRST_NAME] [LAST_NAME] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i merge data in a row of cells to be comma separated in on. | Excel Discussion (Misc queries) | |||
Trying to transpose linked data using Paste Special | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
transpose data | Excel Worksheet Functions | |||
How can I transpose data from a spreadsheet into a form that does. | Excel Worksheet Functions |