Hi,

Column A stored Lastname and firstname. I would like to separate it becomes
two columns: One for firstname and one for lastname so that I don't have to
retype all first name or last name in B and C columns.
t
Ex:
A B C
Beth.Hellmer Beth Hellmer
Thanks
Chi

you can select the column then go to data & thereafter select text to
columns, after this u have to just click the area from where u want to
segreate into different field

"Chi" wrote:

Hi,

Column A stored Lastname and firstname. I would like to separate it becomes
two columns: One for firstname and one for lastname so that I don't have to
retype all first name or last name in B and C columns.
t
Ex:
A B C
Beth.Hellmer Beth Hellmer
Thanks
Chi