How to add an * to the end of each zip code
Posted by Deirdre on May 11, 2001 12:23 PM
Hi, I know this must be hilariously easy - but I cannot find the answer. Using zip code finder software, I have exported all the zip codes for Northern California into a column in Excel so that I can add an * (to include all 9 digit areas) to the end before copying them to a query in Access. For example, I want 92134 to become 92134* without having to do it manually?
I thought I would be able to use Search & Replace. However, each of the 2500 zip codes is different. how do I easily add an * the the end of each one without having to manually type it? Thanks. Deirdre