Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting a message box program to run (Page 43 of 'BeginningProgramming with VBA' by Duane Birnham) 11
combining data from two columns into one 1
Identify Duplicates that are not identical 4
Is there a way to separate FirstName and LastName ? 4
Show only rows with duplicate values in a column? 4
Merging files with nearly identical values in one column 3
Pesky spaces 1
access 2

Back
Top