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