Picking Text from one cell

[tycasey17]

I am trying to pull information from one cell and put it into three other cells on a different sheet. I have a list of addresses and all of them are formatted as 123 America St, Bald Eagle, US 55555. My version of excel doesn't allow for =TEXTAFTER function and was wondering if there is another way to extract that information.

Sheet1
123 America St, Bald Eagle, US 55555
Sheet2
City	State	Zip Code
Bald Eagle	US	55555

 

[Z51]

Example if full address is in A1, and all addresses are formatted similarly... ending in a 2-character state abbreviation and 5-digit zip code.

B1:

=LEFT(MID(A1,FIND(",",A1)+2,LEN(A1)),FIND(",",MID(A1,FIND(",",A1)+2,LEN(A1)))-1)

C1:

=LEFT(RIGHT(A1,8),2)

D1:

=RIGHT(A1,5)

 

[tycasey17]

That worked just like I wanted it to thank you