Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula for taking text out of column B and placing it into column
I am using Excel 2007-
I have hundreds of products (2 listed below: TU10 & TU12) The products have a 'VariantInventoryItemNumber' such as the 2 items below. I need to take all of the text before the ' - ' sign and place that in column A as illustrated below. ItemNumber VariantInventoryItemNumber TU10 TU10-10 TU10 TU10-10.5 TU10 TU10-11 TU10 TU10-11.5 TU10 TU10-12 TU10 TU10-12.5 TU10 TU10-13 TU10 TU10-6 TU10 TU10-6.5 TU10 TU10-7 TU10 TU10-7.5 TU10 TU10-8 TU10 TU10-8.5 TU10 TU10-9 TU10 TU10-9.5 TU12 TU12-10 TU12 TU12-10.5 TU12 TU12-11 TU12 TU12-11.5 TU12 TU12-12 TU12 TU12-12.5 TU12 TU12-13 TU12 TU12-6 TU12 TU12-6.5 TU12 TU12-7 TU12 TU12-7.5 TU12 TU12-8 TU12 TU12-8.5 TU12 TU12-9 TU12 TU12-9.5 For Example: Column B: (VariantInventoryItemNumber) TU32-10.5 TU32-11 TU32-11.5 TU32-12 TU32-12.5 TU32-13 TU32-7 TU32-7.5 TU32-8 TU32-8.5 TU32-9 TU32-9.5 Now I need only the 'TU32' from that listing to be placed into column A using a formula... Any Help? Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula for taking text out of column B and placing it into column
Hi,
in column A enter =TRIM(LEFT(B1,FIND("-",B1)-1)) copy formula down if this helps please click yes thanks "urlocaljeweler" wrote: I am using Excel 2007- I have hundreds of products (2 listed below: TU10 & TU12) The products have a 'VariantInventoryItemNumber' such as the 2 items below. I need to take all of the text before the ' - ' sign and place that in column A as illustrated below. ItemNumber VariantInventoryItemNumber TU10 TU10-10 TU10 TU10-10.5 TU10 TU10-11 TU10 TU10-11.5 TU10 TU10-12 TU10 TU10-12.5 TU10 TU10-13 TU10 TU10-6 TU10 TU10-6.5 TU10 TU10-7 TU10 TU10-7.5 TU10 TU10-8 TU10 TU10-8.5 TU10 TU10-9 TU10 TU10-9.5 TU12 TU12-10 TU12 TU12-10.5 TU12 TU12-11 TU12 TU12-11.5 TU12 TU12-12 TU12 TU12-12.5 TU12 TU12-13 TU12 TU12-6 TU12 TU12-6.5 TU12 TU12-7 TU12 TU12-7.5 TU12 TU12-8 TU12 TU12-8.5 TU12 TU12-9 TU12 TU12-9.5 For Example: Column B: (VariantInventoryItemNumber) TU32-10.5 TU32-11 TU32-11.5 TU32-12 TU32-12.5 TU32-13 TU32-7 TU32-7.5 TU32-8 TU32-8.5 TU32-9 TU32-9.5 Now I need only the 'TU32' from that listing to be placed into column A using a formula... Any Help? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Taking a column from several worksheets; combining into another... | Excel Worksheet Functions | |||
Row/Column Delete taking longer time | Excel Discussion (Misc queries) | |||
Sorting a Column and taking row information with it. | Excel Worksheet Functions | |||
placing numbers in one column at intervals of 2nd | Excel Discussion (Misc queries) | |||
Why is my chart placing one column on top of another when I use a. | Charts and Charting in Excel |