String Handling

Hap

Well-known Member
Joined
Jul 20, 2005
Messages
647
I have a string that looks like this:

string1 = "A1, A2, B4, C8, M5, X2, Z1"

I would like a simple boolean to let me know if:

string2 = "B4"

is found in string 1.

I am sure this is possible but I don't know how to do it.

Any help would be appreciated.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

KenCriss

Active Member
Joined
Jun 6, 2005
Messages
323
Is string 2 going to be another cell in the worksheet or would the user be identifying it in an InputBox?
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Like this?

Code:
Sub Test()
    Const string1 = "A1, A2, B4, C8, M5, X2, Z1"
    Const string2 = "B4"
    MsgBox InStr(1, string1, string2) > 0
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,118,521
Messages
5,572,627
Members
412,475
Latest member
JaredNAU
Top