Re: Remove specific text from a column of cells

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


One TOO simple way would be to have a helper column
=left(a2,len(a2)-11)
Leaves a space on the single digit but probably doesn't matter.

--
Don Guillett
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"Sweepea" <Sweepea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FACB73DB-F9E0-4DA4-9A22-0C6507F8CC73@xxxxxxxxxxxxxxxx
Example:

Apple and Pear Oct 2,2006
Orange and Lime Oct 30,2006
Pear and Pineapple Oct 6, 2006

I want to remove the date at the end of each cell. Can someone help?
Thank
you.


.

Relevant Pages

  • Re: opinions on logical OR variation
    ... However, presumably a product cannot be both an apple and an orange, ... #define PEAR 3 ... #define PLUM 4 ... > void do_something ...
    (comp.lang.c)
  • Re: Pears
    ... pear sauce and pear butter. ... apple sauce and apple butter. ...
    (rec.food.preserving)
  • Re: Generic term for fruit produced by flowering plants
    ... They offered plain Pepsi, because of the half ... Let alone banana trees. ... Besides apple and pear, it also includes ...
    (sci.lang)
  • The World of Fruit Labels
    ... The web's first fruit label site. ... 4015 Cape Late Top Red [apple] ... 4173 Copefrut ROYAL GALA [apple] ... 4408 Asian Pear ...
    (rec.gardens)
  • Re: fruit and vegitables
    ... Nicky wrote ... > Alan Hardy wrote ... >> Half a pear or apple? ... > I haven't eaten a pear since about 2 months after dx, ...
    (alt.support.diabetes)