string within string

A

andrew29

Board Regular
Joined
Jun 1, 2003
Messages
75
HI everyone

I have a nice long text string and want to find out whether the string "4x4" or "4WD" is contained within it. Basically im searching a string to find out if one of 2 substings exist anwhere within it.

Can anyone help?
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Sort by date Sort by votes
If A1 holds the string, in another cell:

=SUMPRODUCT(--ISNUMBER(SEARCH({"4x4","4WD"},A1)))

EDIT: A result > 0 means that there is a match.
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Solved
VBA Delete rows if cell contains specific text within a string
2
Replies
10
Views
969
Peter_SSs
Peter_SSs
D
  • Solved
IF function that tests for any of one of several text strings
2
Replies
13
Views
208
dkjonesau
D
Knockoutpie
  • Question
Excel Formula to check if two strings exist in the same row on a sheet without specifying the column
Replies
2
Views
242
Knockoutpie
Knockoutpie
R
  • Question
Reference a lookup table to find occurances of these values ANYWHERE in the string of another value
Replies
1
Views
538
etaf
etaf
C
  • Question
VBA-Photos to be imported from Sharepoint Site rather than local drive
Replies
1
Views
189
Micron
M

Forum statistics

Threads
1,215,419
Messages
6,124,796
Members
449,189
Latest member
kristinh

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top