To start, the LEN test should be of the form

LEN(A1)=24

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JonnieP" wrote in message
...
Hi

I am trying to extract data out of a column and break it into 3 columns as
follows:

Data= N Network 01/01/05 JP JPM


=IF(LEN(A1=24),MID(A1,20,3),IF(LEN(A1=25),MID(A1,2 1,3),IF(LEN(A1=26),MID(A1,
22,3)))) etc

Result= JP

What I require it the date, and the Initials in 3 columns without the
initial text.

It appears that the IF part of the statement doesnt work and I can't
figure
out why? They work as an individual statement and excel does not throw any
errors up with the formula.

Any suggestions greatly appreciated.

Regards

John