delete characters at the end
Select the cells (you can select more than them, but those cells should not
have a slash in them if you do), click Edit/Replace from Excel's menu bar,
put /* (that is a slash asterisk) in the "Find what" field and leave the
"Replace with" field empty, then click the "Replace All" button. IF this
doesn't work, then it probably means you have the "Match entire cell
contents" box checked on the additional options section of the dialog
(viewable by pressing the "Options" button); if so, uncheck it and click
the "Replace All" button again.
--
Rick (MVP - Excel)
"Stan" wrote in message
...
I have about 500 cells that end with /2, /3, /4, etc.
is there a way to get rid of any character that follows "/", including
"/"?
thanks,
|