M
Marco Margaritelli
PLEASE, I need a formula to extract the data of an address string.
I know that I could use the =LEFT or =MID or =RIGHT formulas, but since the
lenght of the data varies, I will need something better than that.
The positive thing that the database I have is consistent as show below:
comma and space after the City, and space after the STate.
I have this in A1:
A1= Nashville, TN 37211
I would like a formula that extract the data from A1 giving me these results:
B1= Nashville
C1= TN
D1= 37211
THANKS!
I know that I could use the =LEFT or =MID or =RIGHT formulas, but since the
lenght of the data varies, I will need something better than that.
The positive thing that the database I have is consistent as show below:
comma and space after the City, and space after the STate.
I have this in A1:
A1= Nashville, TN 37211
I would like a formula that extract the data from A1 giving me these results:
B1= Nashville
C1= TN
D1= 37211
THANKS!