Inserting a dash in blank cells
 

I want to insert a dash if a cell has no data. When I tried the "IF" function
it gives a circular reference error.

Is there another way to do this?

Thanks

Inserting a dash in blank cells
 

Select the range of cells where you want this to happen
Hit function key F5
Click SpecialBlanksOK
Type a dash then hold down the CTRL key then hit Enter

--
Biff
Microsoft Excel MVP


"UT" wrote in message
...
I want to insert a dash if a cell has no data. When I tried the "IF"
function
it gives a circular reference error.

Is there another way to do this?

Thanks

Inserting a dash in blank cells
 

Hi Biff,

Your solution works but is there a way to insert a special character like a
dash automatically when a cell(s) is blank instead of first selecting cells
and doing a manual insert?

"T. Valko" wrote:

Select the range of cells where you want this to happen
Hit function key F5
Click SpecialBlanksOK
Type a dash then hold down the CTRL key then hit Enter

--
Biff
Microsoft Excel MVP


"UT" wrote in message
...
I want to insert a dash if a cell has no data. When I tried the "IF"
function
it gives a circular reference error.

Is there another way to do this?

Thanks

Inserting a dash in blank cells
 

Sounds like you'll need some kind of macro but it depends on what you mean
by automatically. I'd suggest you post in the programming forum.

--
Biff
Microsoft Excel MVP


"UT" wrote in message
...
Hi Biff,

Your solution works but is there a way to insert a special character like
a
dash automatically when a cell(s) is blank instead of first selecting
cells
and doing a manual insert?

"T. Valko" wrote:

Select the range of cells where you want this to happen
Hit function key F5
Click SpecialBlanksOK
Type a dash then hold down the CTRL key then hit Enter

--
Biff
Microsoft Excel MVP


"UT" wrote in message
...
I want to insert a dash if a cell has no data. When I tried the "IF"
function
it gives a circular reference error.

Is there another way to do this?

Thanks

Inserting a dash in blank cells
 

Where will these blank cells reside?

I'm sure you don't mean all blank cells on a worksheet.

Within some range? Why are they blank and in need of a dash?

To have something like that automatically would require some type of event
code or a formula like this entered in C1

=IF(AND(A1<"",B1<""),A1*B1,"-")


Gord Dibben MS Excel MVP

On Sat, 21 Feb 2009 12:05:01 -0800, UT wrote:

Hi Biff,

Your solution works but is there a way to insert a special character like a
dash automatically when a cell(s) is blank instead of first selecting cells
and doing a manual insert?

"T. Valko" wrote:

Select the range of cells where you want this to happen
Hit function key F5
Click SpecialBlanksOK
Type a dash then hold down the CTRL key then hit Enter

--
Biff
Microsoft Excel MVP


"UT" wrote in message
...
I want to insert a dash if a cell has no data. When I tried the "IF"
function
it gives a circular reference error.

Is there another way to do this?

Thanks