formatting cells

[Matt Edwards]

I have an Excel worksheet where one column contains full
names. Last names and first names are separated by
commas. I want to know if there's a way for Excel to
automatically pick apart the names, like it does when I
import comma delimited files. Help!

Thanks,

-ME

 

[Ron de Bruin]

Hi Matt

Check out Data>Text to Columns in the Menubar