Prev: Trouble creating table
Next: Identify Whole Number
From: James on 24 Feb 2010 12:26
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



--
James.
 | 
Pages: 1
Prev: Trouble creating table
Next: Identify Whole Number