Replacing empty cells with '-'

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I replace empty cells in a range of data with the special character - ?
I tried using the following method:
Selecting the range of data, Edit > Goto > Special > Blanks > Point to a
cell in the adjacent column with ' - '...
When I selected the first cell in the adjacent column, the blanks in the
selected range is replaced with ' - ' as desired. but if any other cell in
teh adjacent column is selected, the some blanks in the selected range are
filled with 0's.
What is the reason for this?
 
It doesnot fill 0's, it fills 1, 2, 3 or 4... PS. my data contain only these
numbers. I also want to know whether this has any relevance.
This happens even if I selcted the 1st cell in a different column!!!
 
try mark the cells u vant the '-' in
press the '-' button, then hold CTRL and press ENTER




"Kazuki" skrev:
 
This small trick works a lot. Thank you excelent!!!

However, I would still like to know why the method I used gave errors!!
 
sry i dont kno :-)

maby u can help me width my problem ?
i cant start a new question
i try click on new, select question, but nothing happens
any sugestions ?
if not, can u make a question for me please ?
 
Hi Excelent, when you select New and click question, a pop-up window is
opened. the way it does when you reply! Check whether pop-ups are allowed...
If this is also not working, I can only ask you to try using what I had to
do the first time...
I was searching for a query, while displaying the results, it gave an option
"search again/ post a new query".... try this
Regards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Event recognition. 6
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Complex date VBA - insert a certain weekday 5
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
VBA set thick borders around non empty cells in range 0
Display if cell contains data 4
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
help with Conditional formatting pairs of cells 1

Back
Top