Splitting data in a cell

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
 
G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting data in a cell 1
How do I add amounts referencing specific dates? 7
SUMIF Formula Help 8
Specific Date from a Range 3
Payroll 1
Find then highlight in yellow 6
Sum value between two dates and copy to new cell 6
Looping through data with calculations 1

Top