Remove specific text from a column of cells
Based on your samples the date appears after the 3rd space. If that's
consistent within your data:
=LEFT(A1,FIND("~",SUBSTITUTE(A1," ","~",3))-1)
Biff
"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.
|