Delete Certain Text From Cells

  • Thread starter Adding Text Without Deleting
  • Start date
A

Adding Text Without Deleting

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)?
 
R

Rick Rothstein

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))
 
J

Jacob Skaria

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&"0123456789")),LEN(A1))

If this post helps click Yes
 
Top