Pull certain text from cell

[gtd526]

Hello,
Regarding AF1 & AK1. I want AK1 to look like AF1 (no numbers).
thank you.

NBA.xlsm
	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP
1	Asst/Tovr Ratio (U:U)	◄ length will differ ►				009- Ct of 9		(make AK1 look like AF1)(no Numbers)
2	Indicates MAX $$		Lime = 4, 250, 140			Indicates MAX %		Pink = 255 , 110 , 170
3	10a	10a- Asst/Tovr Ratio (U:U)	$54.70			009	009- Ct of 9	100.0%
Favs

Cell Formulas
Range	Formula
AF1,AK1	AF1	=IF(LEN(LEFT(AG3,SEARCH("-",AG3)+4))=21,RIGHT(AG3,21),RIGHT(AG3,21))
AG1	AG1	=UNICHAR(9668)&" length will differ "&UNICHAR(9658)
AF3,AK3	AF3	=IF(LEN(LEFT(AG3,SEARCH("-",AG3)-1))=3,LEFT(AG3,3),LEFT(AG3,1))
AG3	AG3	=OFFSET(INDIRECT(INDEX(NBAGL,MATCH(MAX(N(INDIRECT(NBAGL))),N(INDIRECT(NBAGL)),0))),-7,-3)
AH3	AH3	=MAX(AI12,AN12,AS12,AI21,AN21,AS21,AI30,AN30,AS30,AI39,AN39,AS39,AI48,AN48,AS48,AI57,AN57,AS57,AI66,AN66,AS66,AX12,AX21,AX30,AX30,AX39,AX48,AX57,AX66)
AL3	AL3	=OFFSET(INDIRECT(INDEX(NBAMaxRange,MATCH(MAX(N(INDIRECT(NBAMaxRange))),N(INDIRECT(NBAMaxRange)),0))),-2,-4)
AM3	AM3	=MAX(AJ7,AO7,AT7,AJ16,AO16,AT16,AJ25,AO25,AT25,AJ34,AO34,AT34,AJ43,AO43,AT43,AJ52,AO52,AT52,AJ61,AO61,AT61,AY7,AY16,AY25,AY34,AY43,AY52,AY61)
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[maabadi]

Your formula at AF1 & AK1 is Right with 21 Character this for the next column row 3, And for AK1 is correct. Exactly what you want to see at AK1?

 

[Fluff]

Your formulae in AF1 & AK1 make no sense, you are using the last 21 characters in the cell regardless of the IF.
Maybe

=MID(AG3,find("-",AG3)+1,99)

 

[gtd526]

Your formulae in AF1 & AK1 make no sense, you are using the last 21 characters in the cell regardless of the IF.
Maybe

=MID(AG3,find("-",AG3)+1,99)

Perfect, of course. I browse the internet for solutions, and go with whatever works. Then I found this website, and come here for all questions, as maybe you've noticed. You've helped me several times.
thank you

 

[Fluff]

You're welcome & thanks for the feedback.