ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   check if a string contains a particular character (https://www.excelbanter.com/excel-programming/430887-check-if-string-contains-particular-character.html)

kalle

check if a string contains a particular character
 

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 ***

Ron Rosenfeld

check if a string contains a particular character
 

On Thu, 09 Jul 2009 03:22:47 -0700, kalle 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

Ron Rosenfeld

check if a string contains a particular character
 

On Thu, 09 Jul 2009 06:47:19 -0400, Ron Rosenfeld
wrote:

Look at the Instr method
--ron


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

kalle

check if a string contains a particular character
 



Hi

Thanks for your help!

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


All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com