Posted to microsoft.public.excel.programming

michael.beckinsale michael.beckinsale is offline

external usenet poster

Posts: 274

Query - Formula (Test for string)

Hi mralmac,

Try this

If Left(Range("B4").Value, 3) = "CD-" Then

Regards

Michael Beckinsale

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Test String	LucB	Excel Discussion (Misc queries)	2	November 29th 06 02:49 AM
test if a character in a string is alpha	Matilda	Excel Programming	7	October 16th 06 02:36 PM
How to test text string to know if it is a date	itarnak[_4_]	Excel Programming	2	October 7th 05 02:03 PM
Test for exact match in string	Jeremy Gollehon[_2_]	Excel Programming	3	August 24th 04 12:58 AM
Test a String to see if it begins with a Number	Randy[_10_]	Excel Programming	3	October 8th 03 12:37 PM

All times are GMT +1. The time now is 01:53 AM.

About Us

"It's about Microsoft Excel"