You don't need all the if statements either
=MID(A1,LEN(A1)-15,8) is the date
=MID(A1,LEN(A1)-6,2) is the first set of two initials
=MID(A1,LEN(A1)-3,3) is the second set of three initials
Unless I miscounted
-----Original Message-----
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, 21,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
.
|