Hi,
I have the following data (x200 with all a different information that I
want to have an IF formula in the colomn next to the specific data when
if there is for instance for the line that says .MADZBIB that I want
only Excel to take the MID(cell;2ndletter till the 7nd letter) but ONLY
if the line starts with a dot (.) and for the ones that do not start
with a dot I want to Excel to do nothing. After that I want Excel to
place the first 7 digits after the dot in the cell.

The input:
Message is displayed from SITA archiv: 6353636 08.11.2006 01:05:23
QD HAMBI7X
..MADZBIB 072349 NOV06/AGNT9999/PID43007
#CAM
S1BOOKED/IBM/D4296/USD/1/
441/48011057301/D5331034701200/1/EA/2790.00/08116/MFR FAPE3/PRI AOG/
ACN 1027/PKG 0/VRN ESA28017648

=(IF(".";"MID(cell;2;7))")) does not work obviousbly because the line
only starts with a dot. How do I put this in the IF formula? That
instead of bigger than or smaller than or =, one for it starts
with........

Who knows???? I can not seem to figure it out and it has been taking up
a lot of my time to get it right...

I really hope someone can help me!

=IF(LEFT(cell;1)=".";MID(cell;2;7);"")

Regards,
Stefi

€ždebbedeb€� ezt Ã*rta:

Hi,
I have the following data (x200 with all a different information that I
want to have an IF formula in the colomn next to the specific data when
if there is for instance for the line that says .MADZBIB that I want
only Excel to take the MID(cell;2ndletter till the 7nd letter) but ONLY
if the line starts with a dot (.) and for the ones that do not start
with a dot I want to Excel to do nothing. After that I want Excel to
place the first 7 digits after the dot in the cell.

The input:
Message is displayed from SITA archiv: 6353636 08.11.2006 01:05:23
QD HAMBI7X
..MADZBIB 072349 NOV06/AGNT9999/PID43007
#CAM
S1BOOKED/IBM/D4296/USD/1/
441/48011057301/D5331034701200/1/EA/2790.00/08116/MFR FAPE3/PRI AOG/
ACN 1027/PKG 0/VRN ESA28017648

=(IF(".";"MID(cell;2;7))")) does not work obviousbly because the line
only starts with a dot. How do I put this in the IF formula? That
instead of bigger than or smaller than or =, one for it starts
with........

Who knows???? I can not seem to figure it out and it has been taking up
a lot of my time to get it right...

I really hope someone can help me!