Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combine names seperated by comma
I have a database imported into excel, column a has surname and Christin
names seperated by a comma, ie Adams,John want to extract these into another column as John Adams |
#2
|
|||
|
|||
Jason Morin wrote:
1. Select the column. 2. Go to Data Text to columns 3. Select "Delimited" and select a comma as your delimiter. 4. Switch the columns around. And then concatenate, as the OP wants both in the same column! -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
#3
|
|||
|
|||
1. Select the column.
2. Go to Data Text to columns 3. Select "Delimited" and select a comma as your delimiter. 4. Switch the columns around. HTH Jason Atlanta, GA -----Original Message----- I have a database imported into excel, column a has surname and Christin names seperated by a comma, ie Adams,John want to extract these into another column as John Adams . |
#4
|
|||
|
|||
?B?YmJjMQ==?= wrote
I have a database imported into excel, column a has surname and Christin names seperated by a comma, ie Adams,John want to extract these into another column as John Adams Put this in the target column where imported names start in ColA, Row2 =RIGHT($A2,LEN($A2)-FIND(" ",$A2))&" "&LEFT($A2,FIND(",",$A2)-1) Adjust $A2 to your source -- David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
how can I count distinct names in an excel list? | Excel Discussion (Misc queries) | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) | |||
.CSV file format - comma or semi-colon? | Excel Worksheet Functions |