How to search within a single cell

[Etrnal168]

Hey guys, first of all, thanks for reading.

I want to be able to search for a string in a cell. For example,

The content and location of the cell is 'Storage(PCI-X)' and cells(1,1)

and I would like to search to see if the content contains PCI-X

can I do

with .range(cells(1,1))
set c = .find('PCI-X', LookIn:=xlValues, lookat:=xlWhole)

if c = true
blahblah
else
blah blah


Thanks!

-Tom

[Dave Peterson]

Take a look at instr in VBA's help.

dim myStr as string
mystr = Worksheets("sheet1").Range("A1").Value
If InStr(1, mystr, "PCI-X", vbTextCompare) > 0 Then
'found it
Else
'nope
end if

Etrnal168 wrote:
>
> Hey guys, first of all, thanks for reading.
>
> I want to be able to search for a string in a cell. For example,
>
> The content and location of the cell is 'Storage(PCI-X)' and
> cells(1,1)
>
> and I would like to search to see if the content contains PCI-X
>
> can I do
>
> with .range(cells(1,1))
> set c = .find('PCI-X', LookIn:=xlValues, lookat:=xlWhole)
>
> if c = true
> blahblah
> else
> blah blah
>
> Thanks!
>
> -Tom
>
> --
> Etrnal168
> ------------------------------------------------------------------------
> Etrnal168's Profile: http://www.excelforum.com/member.php...o&userid=25135
> View this thread: http://www.excelforum.com/showthread...hreadid=492343

--

Dave Peterson

[BenjieLop]

Hey guys, first of all, thanks for reading.

I want to be able to search for a string in a cell. For example,

The content and location of the cell is 'Storage(PCI-X)' and cells(1,1)

and I would like to search to see if the content contains PCI-X

can I do

with .range(cells(1,1))
set c = .find('PCI-X', LookIn:=xlValues, lookat:=xlWhole)

if c = true
blahblah
else
blah blah


Thanks!

-Tom

The formula

=not(iserror(search("PCI-X",A1)

will let you know if the string "PCI-X" is in Cell A1.

From here, you can use "if c = true, blahblah else blah blah" but you have to convert it to the ff Excel syntax, i.e.,

=if(condition or argument,value if argument is true,value if argument is false)

Hope this helps ...

[Etrnal168]

Thank you guys sooo much!

-Thomas

[BenjieLop]

Thank you guys sooo much!

-Thomas

Thank you for the feedback.

Regards.