View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CJ Melo CJ Melo is offline
external usenet poster
 
Posts: 2
Default CSV Column Conversion

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?