Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I seperate the demensions from the description?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I seperate the demensions from the description?
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. " wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I seperate the demensions from the description?
Tribal Fio,Bottle,Xl dia9x26"h
Wire Sculpture,Ceramic 10x10x52"h |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I seperate the demensions from the description?
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I seperate the demensions from the description?
Thank you for your help, this is great.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically show all comments on a seperate worksheet? | Excel Discussion (Misc queries) | |||
Excel should open workbooks in seperate windows like Word does | Excel Discussion (Misc queries) | |||
how do i seperate data from one column into two seperate ones in . | Excel Discussion (Misc queries) | |||
Refer to seperate workbook for validation list for drop downs? | Excel Discussion (Misc queries) | |||
The description of the ATAN2 function in Microsoft Excel is not 1. | Excel Worksheet Functions |