HELP! Need to separate all characters to the left or right of a value

[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