convert one field into two

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bcap - 29 Jun 2007 14:52 GMT

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!

Reply to this Message

AKphidelt - 29 Jun 2007 15:56 GMT

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

> Hello,
>
[quoted text clipped - 3 lines]
>
> thank you!

Reply to this Message