C
cfletcher1971
I thought I knew this one but it isn't working. I have a list of about
3,500 employee names in the format Lastname, Firstname in column A. The
# of characters is varied of course for the lastname and firstname
values.
In column B I need to parse out all of the "Lastname" values (so
everything to the left of the comma character) and in column C I need
to parse out all of the "Firstname" values.
Here's what I tried:
=LEFT(A2,FIND(",",A2,1))
But it didn't work! Any help is very much appreciated. I have a
deadline of today to get this done :-(
Thanks
3,500 employee names in the format Lastname, Firstname in column A. The
# of characters is varied of course for the lastname and firstname
values.
In column B I need to parse out all of the "Lastname" values (so
everything to the left of the comma character) and in column C I need
to parse out all of the "Firstname" values.
Here's what I tried:
=LEFT(A2,FIND(",",A2,1))
But it didn't work! Any help is very much appreciated. I have a
deadline of today to get this done :-(
Thanks