Splitting data in a cell

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hi all

I have a list of data in a column (see below) which I need to split the last
10 characters (date) from the rest. I can't use text to columns as no
characted separates the data from the date, and I can't use fixed width as
the data before the data varies from 2-4 charaters. 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
NI24/07/2010
 
Are you using Excel or Word? If Excel, try this.

Your data from below should be in column A, rows 1-the end.
Cell C1 =right(a1,10)
cell b1 =left(a1,len(a1)-len(c1))

That will split the cell into column B and C. Column C will hold the last
10 characters, column B will hold the rest.
 
Back
Top