We have software for our medical office that generates a patient list. Unfortunately, the XLS document that is generated places the patients name and address into a single field. I need to break that single field/cell into LAST NAME, FIRST NAME, ADDRESS LINE 1, ADDRESS LINE 2, CITY, STATE, ZIP.
For example, the entire cell might read
Bob Smith
123 Main Street
Apt A
Mytown, NY 12345
Or possibly:
Bob Smith
123 Main Street
Mytown, NY 12345
I am completely at a loss how to do this. Any help is greatly appreciated.
Bookmarks