From you example it appears that your item description is of variable length
and, perhaps, might at times exceed the length of another item description
and its dimension. So, here is a possible different approach.

Assuming Column A contains the original item description and dimensions, in
Cell B1 type =LEFT(A1,LEN(A1)-15) and Enter, then select your range and type
Ctrl+D. The formula means take the length of cell A1, delete the 15 leftmost
characters and show the result. You may need to adjust the 15 up or down to
account for the maximum length of the dimension.

In Cell C1 type =TRIM(SUBSTITUTE(RIGHT(A1,15),CHAR(160),CHAR(32))) , then
Enter, then select your range and type Ctrl+D. This formula basically means
take the 15 rightmost characters in Cell A1, and remove any leading spaces.
Again you may need to adjust the 15 up or down to account for the maximum
length of the dimension.

To remove the formulas, select columns B and C, Copy, then Edit Paste
Special Values and click OK.

Now,

" wrote:

Tribal Fio,Bottle,Xl dia9x26"h
Wire Sculpture,Ceramic 10x10x52"h