Posted to microsoft.public.excel.programming

Raj[_2_]

external usenet poster

Posts: 150

Matching strings with a pattern

Hi,

I have cells containing strings of the type "Mumbai - 400078" and
"Belgaum - 590011" with the following pattern:
Alphabetic string followed by space followed by hyphen followed by
space and then a numeric string. I want to fill such cells with a
color (interior.colorindex)? How do I identify such cells to the code?

Thanks in Advance for the help.

Regards,
Raj

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
Pattern Matching	[email protected]	Excel Discussion (Misc queries)	6	September 24th 07 09:19 PM
Pattern Matching using LIKE ?	Jakobshavn Isbrae	Excel Programming	2	December 31st 06 01:18 PM
VBE replace with pattern matching?	RB Smissaert	Excel Programming	2	August 13th 06 02:18 PM
pattern matching possible?	vito	Excel Worksheet Functions	1	May 16th 06 05:03 PM
Pattern Matching with cells function	John[_80_]	Excel Programming	2	June 29th 04 04:51 AM

All times are GMT +1. The time now is 11:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us