View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Timur Timur is offline
external usenet poster
 
Posts: 1
Default checking the content of a cell if it starts with certain character

I want to calculate something if the content of the reference cell begins
with "PN"
I tried to use "if" formula as below ;
if A2=PN# or * but it did not work

I will be gled if somebody help me
thanks
timur