Hi all,

I have this data


Reg 01 46107 20JUN2016
Reg 01 45307 20MAY2016
Reg 01 44493 20APR2016
Reg 01 43621 20MAR2016
Reg 01 42786 20FEB2016

Now at first each line is in 1 cell. eventually in my VBA code i get it to text to columns it.

Now, i need to remove Reg at the start. The reason i'm finding this hard is because sometimes the data starts with just an R and sometimes nothing at all - just the number. Most of the time there is no space between the R and the numbers which is why i've only just discovered this problem...

Any ideas?

Cheers