I have a spreadsheet and I have to fix zip codes everyday for the map to read them
Example if zip code is 66606-5648 map will read the zip code,
but if its 66606 it will not read it
I need to macro that It will fix the zip code form 66606 to 66606-5648 the zip code doesn’t have to have the correct last four digits just any last four digit I attach a sample of the file
Any help will be greatly apreciate
Last edited by martinez_pedro; 03-31-2009 at 01:43 PM.
Posting files which initiate downloads will likely reduce the number of people willing to help.
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Maybe in I48 and copy down, =TEXT(LEFT(SUBSTITUTE(I2, "-", "") & "000000000", 9), "00000-0000")
Entia non sunt multiplicanda sine necessitate
thankyou very much shg that formula works thx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks