Thread: Delete Certain Text From Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adding Text Without Deleting[_2_] Adding Text Without Deleting[_2_] is offline
external usenet poster
  
Posts: 2
Default 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)?

Reply With QuoteReply With Quote