Thread: How do I ask a cell to look only at the first character in a cell
View Single Post
  #11   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 posed the question wrong. What I really want is a sum of a column with the
first letter of every cell being the variable.

Thanks
--
DMM


"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