J
James
Hi all
I have a column of data (sample below) and I need to split the date (last 10
characters) from the rest of the cell contents. I can't use text to columns
as there is no character between the code and the date and I can't use fixed
width because the code at the beginning can be 2,3 or 4 characters. Any ideas?
SES106/07/2010
YG07/08/2010
TB23/04/2010
MD15/09/2010
NBH12/08/2010
DCL14/03/2010
TTE25/07/2010
EC13/11/2010
MG27/03/2010
SY08/04/2010
I have a column of data (sample below) and I need to split the date (last 10
characters) from the rest of the cell contents. I can't use text to columns
as there is no character between the code and the date and I can't use fixed
width because the code at the beginning can be 2,3 or 4 characters. Any ideas?
SES106/07/2010
YG07/08/2010
TB23/04/2010
MD15/09/2010
NBH12/08/2010
DCL14/03/2010
TTE25/07/2010
EC13/11/2010
MG27/03/2010
SY08/04/2010