Splitting data in a cell

  • Thread starter Thread starter James
  • Start date Start date
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
 
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
 
Back
Top