Columns
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 |
All times are GMT +1. The time now is 05:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com