On 27 Dec 2005 09:19:03 -0800, tr2usa@yahoo.com wrote:

>I have 7k items in my list and I would like to pull demensions from
>descriptions to calculate cubic meter. Which formula helps me out?
>example: (Three Noodle Chair,Rattan 38x48x31"h)
>Thanks for the help.

Not sure exactly what you want.

If you want to "pull" the last "phrase", e.g. 38x48x31"h, then the following
formula:

=MID(A1,FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),
LEN(A1)-LEN(SUBSTITUTE(A1," ","")))),255)

Since you want to do calculations, though, you may want to split things up and
either calculate the volume of a cube or a cylinder, depending on whether there
are two or three numbers.


--ron