Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Certain Text From Cells
I have Excel 2007 and I have over 5000 products. Each product has different
text. For example one cell says (spray 2.5oz) the next cell says (edu spray 3.3oz). Picture over 5000 cells with this kind of data. How do I delete all of the text except for the (2.5oz or the 3.3oz)? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Certain Text From Cells
If, as your two examples show, your quanity and units are always the last
text in the cell **AND** if they are always connected together without a space character between them, then try this formula... =TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99)) -- Rick (MVP - Excel) "Adding Text Without Deleting" om wrote in message ... I have Excel 2007 and I have over 5000 products. Each product has different text. For example one cell says (spray 2.5oz) the next cell says (edu spray 3.3oz). Picture over 5000 cells with this kind of data. How do I delete all of the text except for the (2.5oz or the 3.3oz)? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Certain Text From Cells
Another way..
The below formula will extract contents from the 1st numeric onwards..Try and post back whether this will work for all your data? spray 2.5oz body spray 2.5oz =MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"01234 56789")),LEN(A1)) If this post helps click Yes --------------- Jacob Skaria "Adding Text Without Deleting" wrote: I have Excel 2007 and I have over 5000 products. Each product has different text. For example one cell says (spray 2.5oz) the next cell says (edu spray 3.3oz). Picture over 5000 cells with this kind of data. How do I delete all of the text except for the (2.5oz or the 3.3oz)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I delete cells containing text within a range of cells | Excel Discussion (Misc queries) | |||
Delete Repeating text in cells | Excel Discussion (Misc queries) | |||
How do I delete text to right of a comma in a range of cells? | Excel Discussion (Misc queries) | |||
Delete text in cells but keep formula | Excel Worksheet Functions | |||
Delete asterisks from text in cells? | Excel Worksheet Functions |