Web Development

Ask something
Discussion Locked

Excel replace cell with constant

0 helpful
3 replies

by hurdk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by dklippert

Select the column.
Go to Edit>Replace.
In the Find box use wildcards:

*2001*

in the Replace box enter

1

This discussion is closed to new replies.