I ended up using petes suggestions with and extra if statement that said
that if the cell is less than 2 numbers the result is "". This prevented
me from having 0's show up when there was no zipcode provided.

I was trying to write the formula along these lines and could remember
that is was the & symbol that I was needing to make it all come
together.

Thanks


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=500920