replace value in a column

**gstevens** · 03-13-2013, 02:40 PM

How can I look at the values in a column and if it's only 0 then replace it with call. Problem is when I search it finds every cell that 0 is in even if it's part of a number. so I want to replace 0 with call but not 10 with 1call.

**martindwilson** · 03-13-2013, 02:42 PM

filter on 0
overwrite the first 0 with call ,drag down while filtered, unfilter

**gstevens** · 03-13-2013, 03:01 PM

That's sound pretty simple but I'm a novice. Hate ask but can you give me step by step.

Thanks for responding.

**manoj.0790** · 03-13-2013, 03:01 PM

The best way is to use Filter the data as Martindwilson said above.

If still you want to use Find option make sure you have checked "Match Entire Cell Contents"in Find options.

Find option.jpg

Originally Posted by gstevens

How can I look at the values in a column and if it's only 0 then replace it with call. Problem is when I search it finds every cell that 0 is in even if it's part of a number. so I want to replace 0 with call but not 10 with 1call.

**martindwilson** · 03-13-2013, 03:08 PM

some help on auto filter here
http://blog.contextures.com/archives...vanced-filter/
and
fill handle here
http://spreadsheets.about.com/od/exc...torial-Hub.htm
but i forgot about
"Match Entire Cell Contents" in find/replace

**gstevens** · 03-13-2013, 04:31 PM

Thanks guys. The find and replace worked great. Didn't know about the exact cell function.

But I am going to read up on the auto filter so I can become more familiar with it.

You saved me a couple of hours worth of work.

**manoj.0790** · 03-14-2013, 12:41 AM

Please Mark this Thread as Solved,

Originally Posted by gstevens

Thanks guys. The find and replace worked great. Didn't know about the exact cell function.

But I am going to read up on the auto filter so I can become more familiar with it.

You saved me a couple of hours worth of work.