Hello everybody,
I'm trying to extract (split) information from one (1) column that has the complete adrress to (4) different columns:
- House number and street name
- City
- State
- Postal Code
I was able to extract columns 1, 2 and 4, but the column 3 is given me a trouble, because is havin an extra space at the beginning, Could some one check the formula and help me to find the error.
Example: 156 Windsor Drive, Arlington Heights, IL 60004
The formula that I used was: =MID(A3,FIND(",",A3,FIND(",",A3,1)+1)+1,FIND(" ",A3,FIND(" ",A3)))
But the answer is: " "IL (" " space at the beginning)
Please see the example in the spreadsheet attached
Thanks a lot for the time and help!
SVD