How do you change a text value to value

[CARBOB]

Need to change a 3digit text value to a 3 digit value?

 

[gaz_chops]

example of before & after!

 

[mikerickson]

In VBA, Val("123")
with a worksheet formula N("123")

 

[CARBOB]

In VBA, Val("123")
with a worksheet formula N("123")

The text value is in Q21 110, this formula =ACONCAT(IF(MID($Q21,{1,2,3,4,5},1)+0<5,"L","H")) is in AI21.

 

[gaz_chops]

Have you tried Mikerickson's suggestions?

 

[mikerickson]

What are some typical examples of what might be in Q21?

And what number do you want those examples to result in?