Find a numeric digit on a stored as text cell

[greekboy_uk]

Hi there,
I am trying to find a number within a cell that it is stored as text without converting the cell format to numeric.
I need a formula to check if the first character of the stored as text field is 8 and if so to give me Yes/No result. Many thanks in advance

‘81080999

Yes

 

[AlanY]

try

=IF(LEFT(A1,1)="8","Y","N")

 

[Fluff]

How about
=IF(LEFT(A4)="8","YES","NO")

 

[greekboy_uk]

Thank you works (forgot the “”) and you saved my day ?

 

[Fluff]

Glad we could help & thanks for the feedback