Code to check if cell value start with int.

Rob* · 11-23-2012, 07:04 AM

Hi.

I have a little problem I cant find a solution to.

I want to use some kind of if statement to check if a cell contains a word starting wiht "int" or "Int"
Cell value can be Intern, international, Internet, Intranet, Intellect, interesting or any other word starting with "int"
I tried:

Please Login or Register  to view this content.

But it sems like the wildcard * doesn't work here.
How do I do this?

**nilem** · 11-23-2012, 07:17 AM

Please Login or Register  to view this content.

**martindwilson** · 11-23-2012, 07:18 AM

try using "like"

Please Login or Register  to view this content.

**Bishonen** · 11-23-2012, 07:19 AM

Please Login or Register  to view this content.

Rob* · 11-23-2012, 07:56 AM

Ah!!

Why didn't I come up with the Like function. Been using that long time ago.
Thanks a thousand times to all you who replied.

Code to check if cell value start with int.

LinkBack

Thread Tools

Rate This Thread

Display

Code to check if cell value start with int.

Re: Code to check if cell value start with int.

Re: Code to check if cell value start with int.

Re: Code to check if cell value start with int.

Re: Code to check if cell value start with int.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions