Function to take info left or right of comma?

V

Victoria

Is there a function to take the information to the left or right of a comma?
The issue is that I received a spreadsheet that has lastname, firstname and
I want to separate the two names into two separate fields.
Thanks
 
G

George Nicholson

Easiest way: In Excel: Data>Text-to-columns. Specify comma as the delimiter.
It will split your data into 2 columns.

BACKUP FIRST.

HTH,
 
Top