I have a cell with a name in it in the format of Last Name, First Name. Can excel split out a cell by a character (in this case the comma) so I can have the last name in one cell and first name in another? Example, if cell A1 is Smith, John can excel put Smith in vell B1 and John in C1?