Dave,
Thanks for your help, I shall give it a go.


"Dave R." wrote:

This isn't the most flexible, but should return the watts from 0 to 199, as
long as the sentences had spaces in the right places.

=--MID(A1,FIND("power is",A1)+LEN("power is")+1,3)

if you want it to point at another worksheet, insert this formula into the
worksheet you'd eventually want it pointed at, then select the cell, copy
it, and go to the sheet you'd want it to end up, and paste it there - it
will change the sheet name for you.



"Palmley" wrote in message
...
The second bit.. ."power is xx watts" then extract xx into a cell on
worksheet 1.

Thanks