Finding a specific number in a string

[atius]

Hi

After quite some googling I have been unable to find an answer and turn to you.

I have a lot of random strings each with one to fifteen numbers looking like this:

1,4,6,7,9,11,15
3,6,9
2,6,12,13,14

The string very in numbers in a string.

I am trying to extract each number to a new column and trying to find a solution where I could read the string and i.e. return a false or true if a specific number is in the string. The main problem I have been having is: If I search for 1 it turns up true because of 11, 12, 13, 14 and 15; just like searching for 2 turns up true for 2 and twelve.

I hope you can help me, preferably with a formula since I don't know macros, but I won't turn my back on any viable solution.

Thx :D

 

[Snakehips]

atius,

Welcome to MrExcel.

This does not extract each number to a different cell although we can do that if it is necessary.
It does however give you a True/False in C if number in B is in your string.

Excel 2007
	A	B	C
1	1,4,6,7,11,15	1	TRUE
2	1,4,6,7,11,16	12	FALSE
3	1,4,6,7,11,17	11	TRUE
Sheet1

Cell Formulas
Range	Formula
C1	=ISNUMBER(FIND(","&B1&",",","&A1&","))

Hope that helps.

 

[atius]

Brillant, thank you
I can work with this :D

This forum usually has the answers I am looking for.