Thread: How do I ask a cell to look only at the first character in a cell
View Single Post
  #17   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 c
hold down the Ctrl and Shift keys and then hit Enter.

"soconfused" wrote:

I'm really sorry, I must be really dumb, but how do I do that?
--
DMM


"Toppers" wrote:

Enter with Ctrl+Shift+Enter

"soconfused" wrote:

One more thing, I have this formula =IF(LEFT(H6:H7)="A",SUM(AW6:AW7),"") and
I am getting a value error. HELP please.

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