Thanks Tom

I have opted for this method, only ever used this when importing from text,
it very useful though!

Thanks again

John

"Tom Hayakawa" wrote:

Hi there,

It looks to me like you're getting this data from somewhere else and trying
to parse out some info. If that's the case, and the data in the cells you're
looking at always appears in the same format, have you thought about using
the Text to Columns function to break up the data into separate cells? That
might be quicker and easier, not to mention a whole lot less
processor-intensive.

Tom Hayakawa

"JonnieP" wrote:

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