Extract text or number from a cell / substring

[janema]

If the cell in column F is "Band 4 Target 15%" I am trying to ONLY return the 6th digit, which in this case, would be "4"

My formula is bringing in the entire first part. HELP PLEASE.

 

[Scott Huish]

=MID(F4,6,1)

 

[janema]

=MID(F4,6,1)

YES!!! Thank you so much.

 

[Dave Patton]

With Excel 365

T240203a.xlsm
	F	G	H
1
2
3
4	Band 4 Target 15%"	4	yields text
5	Band x Target 15%"	x	yields text
6	Band 101 Target 15%"	101	yields text
7
1f

Cell Formulas
Range	Formula
G4:G6	G4	=TEXTBEFORE(TEXTAFTER(F4," ")," ")