The entire address for each row is all in one field.
I need to break that address field into multiple columns.
Fortunately, at least there's a delimiter ... there are semicolons (;) at the break points.
EXAMPLE:
I need to take
- "1234 ELIZABETH DR; SOMETOWN MA, 01234; USA;"
and break it into
- "1234 ELIZABETH DR" "SOMETOWN MA, 01234" "USA"
(even better would be to break the city state, zip into 3 columns too, but I'll take what I can get )
NOTE: Some records have PO Boxes rather than street addresses ... if that matters
I've googled around a bit, and I feel like I'm on the right track .. I'm just a bit stuck.
To break out the first section, I'm currently using
Code: Select all
=LEFT(C2,FIND(";",C2)-1)
I'm running into trouble when I try to get the next section.
I'm starting with
Code: Select all
=RIGHT(C2,FIND(";",C2))
.. there is a seemingly-random quantity of char's that get truncated from the left side of the resulting string.
IE, for our example, it returns "N MA, 01234; USA;"
Tips ?
Pointers ?
Secrets of the universe ?
~ Mo