How can I seperate the demensions from the description?

[tr2usa]

I am trying to seperate the demensions from the description and create
another cell for each mesurament. I have 7k items on my list. Which
fromula helps me out?
Thanks.

 

[Guest]

Without seeing an example of the entries in your list, it is difficult to
give you the best approach. That being said, if your items begin with the
dimensions followed by the description, it might work to use Data > Text to
columns. You will need to select how the text is divided (Delimited or Fixed
width)--experiment a little to see what works best for your situation.

 

[tr2usa]

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

 

[Guest]

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,

 

[tr2usa]

Thank you for your help, this is great.