May 24 2019 10:41 AM
I need to separate a column listing addresses into 4 columns, address1, address2, city, state. Text to column does not separate because there is not any comma's only spaces and I cannot separate by spaces because there are required spaces in each part of the address
May 29 2019 03:09 AM
May 29 2019 07:44 AM
Hi @Diane307 Not sure of this will help, I have assumed that some parts of your addresses start with capital letters, the attached file shows how to identify each capitol letter in the address, get its location in the string then extract the remaining lower case letters. of course if you don't have any capitols then life becomes very difficult, if not impossible.
Rich