Hello. I've a list of 700+ text strings. Each string contains information in the following form:
LICENSE NAME | DBA | Street address | City | Zip
* | denotes a single space
**ALL text associated with the license name is capitalized
**The only field with a fixed number of characters is ZIP (5 characters)
For Example:
CARING LEVIS LLC CL Communications 1234 Main Street Portland 97206
CROOKED LICENSE INC. Crooked Business Partners 501 First Avenue Suite 152 Eugene 92573
CURVED & QUIET COLLECTIVE C&C Collective 10089 George Washington Parkway STE 680 Salem 90087
I'd like to segment each string into five separate columns based on the color system above. Does anyone know of an efficient formula that can accomplish this task?
Thanks for any help!
-Matt
Bookmarks