Excel replace cell with constant - TechRepublic
General discussion
February 27, 2003 at 09:34 PM
hurdk

Excel replace cell with constant

by hurdk . Updated 23 years, 4 months ago

I have an Excel spreadsheet.
I need to search for each cell for 2001 in the column.
Each cell will have other unnecessry data besides 2001.
For each cell with 2001 I need to replace the entre cell with 1.
Thank you.

This discussion is locked

All Comments