I'd use:

Select the column with the names
Data|Text to columns
Delimited
by comma
and plop the results into the two adjacent columns.

Make sure you have room so you don't overwrite the adjacent data.

CJ Melo wrote:

Hi
I have a downloaded csv file which has a LastName,FirstName entry under one
column titled LearnerName. I am trying to highlight rows based on the names,
but conditional formatting doesn't seem to like the comma in the name. Short
of manually breaking the name into two columns, is there a way to convert
LastName,FirstName into two separate columns?

--

Dave Peterson