Assuming your logic and example always hold good then the following should
do
Date
=--MID(A1,FIND("/",A1)-2,8) (Format as a date)
Initials
=MID(A1,LEN(A1)-4,3)
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"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
|