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 |
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 |
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 . |
?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 |
All times are GMT +1. The time now is 03:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com