Extract ZIP Code (Numbers) from the left of an address GSHEETS

[yessir]

Hello,

I'm looking for a formula that would be able to extract only the last digits (zip code) from an address. All addresses are formatted the same way.

1253 S Lone Hill Ave, Glendora, CA 91740	formula here to extract zip code (would display 91740)
13910 Poway Rd, Poway, CA 92064

Anything helps! Thanks.

 

[Dwyane]

Hello,

I'm looking for a formula that would be able to extract only the last digits (zip code) from an address. All addresses are formatted the same way.

1253 S Lone Hill Ave, Glendora, CA 91740	formula here to extract zip code (would display 91740)
13910 Poway Rd, Poway, CA 92064

Anything helps! Thanks.

You can use

right(text,5)

. where text is the cell with the address. Hope this helps.

 

[Jimmypop]

Hi there

You can also try the formula below... Should work with varying lengths of zip code should it happen.

Book1
	A	B
1	1253 S Lone Hill Ave, Glendora, CA 91740	91740
2	13910 Poway Rd, Poway, CA 92064	92064
3	1245 Some Address, Elswhere, 125	125
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=RIGHT(A1, LEN(A1)-MAX(IF(ISNUMBER(MID(A1, ROW(INDIRECT("1:"&LEN(A1))),1) *1)=FALSE, ROW(INDIRECT("1:"&LEN(A1))), 0)))

 

[Automatrix]

Power Query alternative:

 

[Fluff]

PQ in Google Sheets?