Nirvana
asked on
extract zip code or specific digits from text address
I have address where I need to extract zip code How can i do that with excel formula. I need to extract last four digits from text and number string . attached is the sample file. I have tried the below formula
MID(TRIM(A1),FIND(CHAR(1), SUBSTITUTE (TRIM(A1), " ",CHAR(1),LEN(TRIM(A1))-LE N(SUBSTITU TE(TRIM(A1 )," ",""))))-4,4) but i might have many spaces
sample.xlsx
MID(TRIM(A1),FIND(CHAR(1),
sample.xlsx
@Shums at line 35, 131, etc wrong result
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are right Rgonzo Sir :(
Perfect Rgonzo Sir :)
ASKER
Brilliant
Open in new window
Please find attached...sample_v2.xlsx