Thread: I need to extract the first 3 digits from a cell (ex: AAG12345)?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob Rob is offline
external usenet poster
  
Posts: 718
Default I need to extract the first 3 digits from a cell (ex: AAG12345)?
I have 26,000 cells that I need to extract just the first 3 digits of the
cell. For example, the cell reads AAG122345 and I need a new cell that only
reads "AAG". How can I do this?
Reply With QuoteReply With Quote