Find position inside of a text string with a delimiter

[Stephen_IV]

Good morning I am trying to figure out how to find out what position a value is in a string separated by /
In the example below I would like to find the position of Mark, any help would be appreciated. Thanks!

Find position inside of a text string with a delimiter.xlsm A B 1 Names = Mark Position inside of the / 2 Mark 1 3 Paul/Don/Jeff/Mark 4 4 Don/Mark 2 5 Fred 0 6 Mark 1 7 Al/Frank/Fred 0 8 Paul 0 9 Mark/Paul 1 10 Al/Kenny/Fred 0 11 George/Larry/Don 0 12 Colby/George/Tom /Don/Fred/Mark/Jeff/Nick 6 Sheet2

 

[Fluff]

How about

Fluff.xlsm
	A	B
1	Names = Mark	Position inside of the /
2	Mark	1
3	Paul/Don/Jeff/Mark	4
4	Don/Mark	2
5	Fred	0
6	Mark	1
7	Al/Frank/Fred	0
8	Paul	0
9	Mark/Paul	1
10	Al/Kenny/Fred	0
11	George/Larry/Don	0
12	Colby/George/Tom /Don/Fred/Mark/Jeff/Nick	6
Main

Cell Formulas
Range	Formula
B2:B12	B2	=IFNA(MATCH("mark",TEXTSPLIT(A2,"/"),0),0)

 

[Stephen_IV]

Fluff! Perfect that is exactly what I need!!! Thank you again!

 

[Fluff]

You're welcome & thanks for the feedback.