Thread: Pulling partial information from a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Pulling partial information from a cell
=LEFT(A1,5)

"Emeryville John" wrote:

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?
Reply With QuoteReply With Quote