Excel Search String for 5 digit zip code

[dddiscus]

Need help with function to search for 5 digit zip code in concatenate
city, state, zip cell. States are not always 2 characters and ther
may be ending spaces or +4 on zip code.

Thanks,
Mar

 

[Frank Kabel]

Hi
and whyt do you want to return? The adjacent column?. If yes try:
=VLOOKUP("*12345*",A1:B100,2,0)

 

[dddiscus]

Tried the function and it is returning N

 

[Frank Kabel]

Hi
you may post some example rows of your data and exlain in detail what
your expected result is (plain text - no attachments please)

 

[dddiscus]

Here are some lines of text from the spreadsheet. I have concatenate
several columns together as there were zip codes in a couple differen
columns.

Thank you,
Mar

Attachment filename: data.txt
Download attachment: http://www.excelforum.com/attachment.php?postid=69273

 

[Frank Kabel]

Hi
you may link an Excel sheet and not a *.txt file

 

[dddiscus]

Here are some rows from the actual spreadsheet.

Thank you,
Mary

Attachment filename: data.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=692806

 

[Frank Kabel]

Hi
and now describe what you're exactly trying to achieve

 

[dddiscus]

I would like to pull the 5 digit zip code out of the column e int
column f.

Thank you,
Mar