Posted to microsoft.public.excel.programming

Timur

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Checking for cell content	danhattan	Excel Programming	6	April 2nd 07 11:48 PM
Checking a String's last character	Ren	Excel Programming	6	August 2nd 06 06:04 PM
Checking to see whether a string contains a certain character	ajitpalsingh200[_21_]	Excel Programming	1	November 26th 04 09:36 AM
Checking for non-numerical content in a cell	Tom Ogilvy	Excel Programming	0	August 15th 03 10:54 PM
split cell content without using a specific character/sign	Donald Lloyd	Excel Programming	0	July 31st 03 11:10 PM

All times are GMT +1. The time now is 09:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us