Thread: How do I ask a cell to look only at the first character in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
soconfused soconfused is offline
external usenet poster
  
Posts: 93
Default How do I ask a cell to look only at the first character in a cell
I am trying to look at a cell and put a #1 in it:

Example Column C = A-LA41-09-92256 I need a formula here
to put a # 1 if the value is A- or H-

Thanks in advance.

DMM
Reply With QuoteReply With Quote