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]
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 Data>Text 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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks