Thread
:
Remove specific text from a column of cells
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Remove specific text from a column of cells
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
"Sweepea" wrote in message
...
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett