Thread: How do I ask a cell to look only at the first character in a cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default How do I ask a cell to look only at the first character in a cell
in D1:

=if(OR(left(C1)="A",left(C1)="H"),1,"")

HTH

"soconfused" wrote:

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