Did you try any of the suggestions?

Did any of them do what you wanted?

debbedeb wrote:

What I want is that if you have all this data, that only in the cells
next to the data with a starting dot there will be the formula used to.
so if there is not a dot at the beginning of the cell there then the
cell is empty and if it does start with a dot; that the mid formula
only gives me the 2nd to the 6th digit in this cell.

Do you understand what I mean??

Dave Peterson wrote:

I'm not sure I understand...

with the data in A1
=if(left(a1,1)=".",mid(a1,2,6),a1)
or
=if(left(a1,1)=".",mid(a1,2,6),"")



debbedeb wrote:

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!

--

Dave Peterson

--

Dave Peterson