Separate info from one field into two fields

[Guest]

I have a field that holds the person's name and address all in one field.
This is because the data entry person cuts and pastes the name address from
another mainframe database on screen when they are filling in the Access
database.

Now they want to export the name and address into a check writing program
that has separate fields for the name and address1 address2 city state
zip.

Any easy way to export the combined field into separate parts to fit the
check writing program's fields?

Thanks for your help.
Connie

 

[Rick B]

This question is asked very often. Please do a search and read the previous
posts. That is why they keep them out there.

The short answer is, "This cannot be done reliably. Too many variables in
number of words, spacing, etc.)

Good luck,