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.
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.