MattehWoo
08-10-2016, 07:40 AM
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
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