Find and Replace

L

LLama

Hi all,

I don't have much experience with Excel so this is probably going to
be a dumb question. How do I find and replace a value for only one
column? For example, I want to find all the blanks in only column J
and replace them with the number 2000.

Thanks.
 
G

Gord Dibben

Select that column and F5>Special>Blanks>OK

In active cell enter 2000 then hit CTRL + ENTER


Gord Dibben MS Excel MVP
 
S

Stephen Bye

LLama said:
Hi all,

I don't have much experience with Excel so this is probably going to
be a dumb question. How do I find and replace a value for only one
column? For example, I want to find all the blanks in only column J
and replace them with the number 2000.
Click to expand...

In general, if there is a selection (i.e. rows, columns or a block of cells
have been selected), then Find and Replace will work only on those selected
cells.
 
Top