Extracting numbers from at beginning of a string

[Peter Davison]

I have the following string in Cell AO2
105 - Aylesbury
All I want is to take the first 3 numeric digits (105) and place it is cell AR2

I've tried all of the following 4 formulas

=RIGHT(TEXTJOIN("",TRUE,IFERROR((MID(AO2,ROW(INDIRECT("1:"&LEN(AO2))),1)*1),"")),3)
=LEFT(AO2,SUM(LEN(AO2)-LEN(SUBSTITUTE(AO2,{"0","1","2","3","4","5","6","7","8","9"},""))))
=SUBSTITUTE(TRIM(CONCAT(TEXT(MID(AO2,SEQUENCE(99),1),"0;;0; ")))," ",",")
=left(AO2,3)

and whilst they all extract 105 when my Vlookup uses the result its showing #N/A because I believe it still thinks its text.
When I do an F9 on the formula it shows the result like this - "105"

I've never had this problem before so I don't know what I am doing wrong.
Any thoughts?
Thanks for your time

 

[Fluff]

How about

=left(AO2,3)+0

 

[Peter Davison]

That is perfect, it seems so simple, but I've never seen that before.
Thank you I've been on it ages.
Appreciate your help.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Peter Davison]

Just a quick separate question.
Sorry if I should send this in separately.
Do you know if I can show only the first legend (left hand bars) in a chart like the chart below?

 

[Fluff]

As this is a totally different question, it needs a new thread. Thanks

 

[Peter Davison]

Okay no problem I’ll send one in tomorrow
Thanks for all your help

 

[Fluff]

My pleasure.