Remove specific text from a column of cells
=LEFT(A1,FIND("Oct",A1,1)-2) will remove the date for October data.
--
Gary's Student
"Sweepea" wrote:
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.
|