Hi,

What I have is a column of mixed text and numbers, this is by clause number and desc. so they look something like this.

Column C

13 – Alcoholic drinks and fermented/brewed products, 15 – Dried foods and ingredients

So I need 13 and 15 put in their own cells in a new column.

Thanks,


In case it helps numbers are 01-18 and yes the zero at the front matters for some reason