vs,

Putting all three dimensions in one cell isn't the best way for a spreadsheet. If you put
them in separate columns, the formula would be simply:
=B2 * C2 * D2

If they're already in the worksheet in that fashion, you can use Data - Text to columns to
separate them.

If you must keep them in one cell separated by "x", then use:
=LEFT(A2,FIND("x",A2)-1)*MID(A2,FIND("x",A2)+1,FIND("x",A2,LEFT(A2,FIND( "x",A2)-1)+1)-FIND("x",A2)-1)*RIGHT(A2,LEN(A2)-FIND("x",A2,LEFT(A2,FIND("x",A2)-1)+1))

See what I mean? Someone may come up with a more concise (but probably still difficult)
formula to handle it, but I recommend the first approach.
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"vs" wrote in message
...
Hi
I need to display volume in one column and the answer in another column.

example 2x3x3 18
(display only) (answer)

How can I do it.
Any help is highly appreciated
Thanks