Splitting data in a cell
 

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


--
James.

Splitting data in a cell
 

With your data in column A, In B1 enter:
=LEFT(A1,LEN(A1)-10) and copy down

and in C1 enter:
=RIGHT(A1,10) and copy down

--
Gary''s Student - gsnu201001


"James" wrote:

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


--
James.

Splitting data in a cell
 

Must learn how to use "LEN"s! Thanks Gary.


--
James.


"Gary''s Student" wrote:

With your data in column A, In B1 enter:
=LEFT(A1,LEN(A1)-10) and copy down

and in C1 enter:
=RIGHT(A1,10) and copy down

--
Gary''s Student - gsnu201001


"James" wrote:

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


--
James.