Try the following...
1) Select/highlight your data (five columns)
2) Edit Go To Special Blanks Ok
3) Enter your unique character
4) Press CONTROL+ENTER
Hope this helps!
In article ,
"Rebecca" wrote:
Hi. I am using MS Excel 2003, and I am very new to the program, so if you
can help me, please explain everything in very easy English.
I need to fill many blank (empty) cells that are located in various places
(there are five columns) throughout a worksheet. I want to fill the blanks
with an "@" (or some other unique character) so I can later search and
replace to remove them easily (after some sorting). How can this be done?
And please explain it so a newcomer can understand. Thanks.
|