Parse out information

  • Thread starter Thread starter Doreen
  • Start date Start date
D

Doreen

In Excel XP,

Is there a way to take this:
138581001.doc owned by pmurphy was printed on 46-C24 via port
10.146.7.8:RAW. Size in bytes: 268699; pages printed: 14

and get
46-C24
and
pages printed:14

Doreen
 
Doreen a écrit :
In Excel XP,

Is there a way to take this:
138581001.doc owned by pmurphy was printed on 46-C24 via port
10.146.7.8:RAW. Size in bytes: 268699; pages printed: 14

and get
46-C24
and
pages printed:14

Doreen
Click to expand...


Hi Doreen,

On my Excel 2000 french (arghh :o))

=STXT(A1;(TROUVE("was printed on ";A1;1))+15;(TROUVE(" via
port";A1;1))-(TROUVE("was printed on ";A1;1))-15)
.... returns 46-C24

=(STXT(A1;(TROUVE(" pages printed:";A1;1));35))
indicates the pages

Some points :
1) Functions have to be translated : I expect STXT to be MID and TROUVE
to be FIND
2) replace ; by ,
3) the number 15 in formulas is related to the length of text you are
looking for (+1 or +2 for spaces).

HTH
FxM
 
Back
Top