Replace every non empty cell

S

serge

Hi,

I want to replace every cell with is not empty in a column with th
word "DEMO". Can someone help me?

Thanks,
Serg
 
D

Debra Dalgleish

To fill the blank cells in the used range of a column:

Select the column
Choose Edit>Go to
Click the Special button
Select Blanks, click OK

Type DEMO
Press Ctrl+Enter
 
J

Jim Rech

Select the range of cells. Then open the Replace dialog (Edit, Replace).
Enter a * (an asterisk) as the Find What text, and DEMO as the Replace With
text. Then click Replace All.

--
Jim Rech
Excel MVP
|
| Hi,
|
| I want to replace every cell with is not empty in a column with the
| word "DEMO". Can someone help me?
|
| Thanks,
| Serge
|
|
| --
| serge
| ------------------------------------------------------------------------
| serge's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=4164
| View this thread: http://www.excelforum.com/showthread.php?threadid=275559
|
 
D

Debra Dalgleish

Oooh...every NON empty cell. <g>

Jim said:
Select the range of cells. Then open the Replace dialog (Edit, Replace).
Enter a * (an asterisk) as the Find What text, and DEMO as the Replace With
text. Then click Replace All.
Click to expand...
 
Top