separating data from one cell to many

  • Thread starter Thread starter drooth
  • Start date Start date
D

drooth

I have cells with data that needs to be separated, example:

1234 Main St. Jamaica, NY 11432 718-222-2222

The address, city, state, zip and phone number need to be automaticall
put into their own separate fields.

1. Can someone offer a formula to deal with this type of situation?

2. Is there one formula that works with other types of data, such a
first name, last name, birthdate, again that need to be separated fro
one cell to many.

3. Can this process be automated with macro, if so, how?

MUCH GRATITUDE TO THE RESPONDERS...
 
I'm no expert but: go to Data > Text to Columns. Follow
the process through - it's pretty straight forward and
works with all types of data. I automated it by recording
a new macro as I went through the process manually. Then
creating an "update" button from the Forms toolbar and
linked it to the macro - I hope this is of use...
 
Back
Top