check if a string contains a particular character

's Computer Specifications

Hi

I have a number of cells in a worksheet that I will read and save to a
database.
Before I save I want to check if the string contains an particular
character.

How do I do that?

*** Sent via Developersdex http://www.developersdex.com ***

's Computer Specifications

On Thu, 09 Jul 2009 03:22:47 -0700, kalle <(E-Mail Removed)> wrote:

>
>Hi
>
>I have a number of cells in a worksheet that I will read and save to a
>database.
>Before I save I want to check if the string contains an particular
>character.
>
>How do I do that?
>
>*** Sent via Developersdex http://www.developersdex.com ***

Look at the Instr method
--ron

's Computer Specifications

On Thu, 09 Jul 2009 06:47:19 -0400, Ron Rosenfeld <(E-Mail Removed)>
wrote:

>Look at the Instr method
>--ron

That should read "Instr Function" (not method).
--ron

's Computer Specifications

Hi

Thanks for your help!

*** Sent via Developersdex http://www.developersdex.com ***

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Check if character exists in string	Lars Brownies	Microsoft Access	2	17th Jan 2010 10:16 PM
Check for character in string	dksaluki	Microsoft Excel Misc	3	11th Dec 2007 12:53 PM
How to check if a string starts with a certain character	garyusenet@myway.com	Microsoft C# .NET	6	2nd May 2006 11:21 AM
Trying to check 3rd character in string as criteria	Duane Hookom	Microsoft Access Queries	4	28th Oct 2004 10:15 PM
Check if first character of string is in array	Jonathan	Microsoft Excel Programming	4	11th Oct 2003 12:07 AM