Hi all,

I am after a formula that will find text in a cell that contains text and numbers and extract the text and put it in the next column along, see below example.

Before:

37 RUE DE LA SPINETTE ZONING IND DE KEUMIEE

After:

RUE DE LA SPINETTE ZONING IND DE KEUMIEE

There are also cases where there is multiples of numbers say, BUILDING 13, 28 LANCASTER STREET.

I look forward to some assistance - many thanks