Thread: Formula that just gets the first few numbers in a cell, not all?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KenCanuck KenCanuck is offline
external usenet poster
  
Posts: 17
Default Formula that just gets the first few numbers in a cell, not all?
I know there's a function or formula in Excel that allows you to just look at
the first or last few numbers in a particular cell. Ex.I need my if then
formula to just look at the first 5 numbers in a cell (the zip code) and
ignore the -3645 behind the zip code. help?
Reply With QuoteReply With Quote