Remove text after first instance of numbers

[ausswe]

Hi, I've been playing around with various formulas to remove text in a cell that comes AFTER the first instance of numbers, for example "Ovre Faltvagen 15 A" should become "Ovre Faltvagen".

I have tried using # as a reference but no luck:
=LEFT(B2; SEARCH(" #"; B2) -1)
=TEXTBEFORE(B2;" #";1)

Anyone with a clever suggestion?

Thanks in advance.

 

[Fluff]

How about

=TRIM(TEXTBEFORE(B2,SEQUENCE(,10,0)))

 

[ausswe]

How about

=TRIM(TEXTBEFORE(B2,SEQUENCE(,10,0)))

Thanks - that worked wonders!

This is me trying to understand: SEQUENCE is the part that states first instance of numbers? And why 10 (columns)?

 

[Fluff]

And why 10 (columns)?

Because there are 10 number (0 to 9)