Posted to microsoft.public.excel.programming

John

external usenet poster

Posts: 2,069

Checking for special characters in a string

How do I check a string to see if it contains any special characters like @$%
etc?

I'm using InputBox to request a name that will be used to define a range
name and range names can consist of alpha, numeric and underscore characters
only.

I appreciate your help, -John

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 special characters in a string	Rick Rothstein	Excel Programming	0	February 4th 09 08:50 PM
Highlighting special characters in a string	Cynthia	Excel Programming	7	November 11th 08 12:51 PM
Special characters in a string variable	[email protected]	Excel Programming	1	August 4th 06 08:36 PM
String Function 'Like' and Special Characters	Vagabond Software	Excel Programming	3	June 12th 04 02:02 AM
Escape for special characters in string	Jag Man	Excel Programming	2	January 2nd 04 03:56 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us