sorry, don.

i am not savvy enough to know how to use what you have supplied.

please explain further so i can test it.

thx for the reply.

andy


"Don Guillett" wrote:

try using

instr
x=instr(string,
y=instr(
' A textual comparison starting at position 4. Returns 6.
MyPos = Instr(4, SearchString, SearchChar, 1)
--
Don Guillett
SalesAid Software

"andy from maine" <andy from wrote in
message ...
is there anyway to get a computed value for the square inches in the
following cell:

LightJet Mural - from Provided File (8.5X11) Normal

I am trying to compute usage from parts that are named with the dimension
embedded in the description - and the dimensions varies with each
description. the dimension is always embedded as shown (widthxheight). the
text string surrounding the numerical data vaires in length

thanks for your collective wisdom, excel gurus...