View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emeryville John Emeryville John is offline
external usenet poster
 
Posts: 4
Default Pulling partial information from a cell

Hi,

Thanks to Dave and Peo for help on my previous request.

I have a list of 5 digit zip codes (eg. 90210) and a list of 5 + 4 digit zip
codes (eg. 90210-1234). How can I pull just the first 5 digits from the 5 +
4 digit zip codes?