Extracting a number for a cell

[gheyman]

I have a row that has values in most of the columns that look like: Char 15 or Char 1 (Some columns are blank or may have a text that doesnt contain Char...)
I need formula where if the cell value does start with "Char" then extract that number. As an FYI the columns that do have Char... its to identify the Max number of characters allowed in that column. Therefore I am trying to extract the number of Characters and then use it in a Len formula Example =(MAX(LEN(MSQ_BySE_QuantityBreakPoints[QT_LN_NOTES]))>250)=TRUE

Thanks

 

[dreid1011]

Is that the only text that would be in a cell? "Char #" ? If so, maybe something like this:

Book1
	A	B	C	D	E	F	G
1
2	Char 15	Char 1			Char 25		Char 30
3	15	1	0	0	25	0	30
Sheet1

Cell Formulas
Range	Formula
A3:G3	A3	=IFNA(TEXTAFTER(A2,"Char "),0)