Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF and LEN and MID Problem
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 |