convert one field into two

  • Thread starter Thread starter bcap
  • Start date Start date
B

bcap

Hello,

I have a name field with a first name and lat name in it. I'd like to
create two new fields and convert it to be first name and last name
individually. is there a way to do this w/o having to do it manually?

thank you!
 
There's actually couple ways. I think the best way if it's just first and
last name without middle initials would be to go to

Data---> Text-To-Columns

Make sure "Delimited is clicked"

Click Next

Then either select Tab, or Comma, or space... whatever your data is
formatted to
Then click Finish
 
Back
Top