Populating empty cells
 

Hi

In column A , I have some cells which contain text , and others which
are blank.

Is there a formula which will fill the empty ones with a dash (-) ,
whilst leaving the full ones intact?

Hope you can help.



Best Wishes


Colin

Populating empty cells
 

Hi

Select the range of cells. Hit F5 and select Blanks from the Special page.
Then type - and hit Ctrl+Enter.

Hope this helps.
Andy.

"Colin Hayes" wrote in message
...

Hi

In column A , I have some cells which contain text , and others which are
blank.

Is there a formula which will fill the empty ones with a dash (-) , whilst
leaving the full ones intact?

Hope you can help.



Best Wishes


Colin

Populating empty cells
 

Try this:

Select the range you want impacted

From the Excel main menu:
Press the [F5] key....(its the shorcut for<edit<goto )
Click the [special cells] button
ChecK: Blanks
Click the [OK] button

(now all the blank cells are selected)

Type: '-
(that's an apostrophe and a dash...if you just type a dash, Excel will try
to build a formula)

Hold down the [ctrl] key and press the [enter] key
(that will put the dash in every selected cell)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Colin Hayes" wrote:


Hi

In column A , I have some cells which contain text , and others which
are blank.

Is there a formula which will fill the empty ones with a dash (-) ,
whilst leaving the full ones intact?

Hope you can help.



Best Wishes


Colin

Populating empty cells
 

Minor correction......
You don't need to put an apostrophe in front of the dash.
***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Try this:

Select the range you want impacted

From the Excel main menu:
Press the [F5] key....(its the shorcut for<edit<goto )
Click the [special cells] button
ChecK: Blanks
Click the [OK] button

(now all the blank cells are selected)

Type: '-
(that's an apostrophe and a dash...if you just type a dash, Excel will try
to build a formula)

Hold down the [ctrl] key and press the [enter] key
(that will put the dash in every selected cell)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Colin Hayes" wrote:


Hi

In column A , I have some cells which contain text , and others which
are blank.

Is there a formula which will fill the empty ones with a dash (-) ,
whilst leaving the full ones intact?

Hope you can help.



Best Wishes


Colin

Populating empty cells
 

Hi

OK That's fixed it!

Thanks all for your help.



Best Wishes


Colin



In article , Ron
Coderre writes
Minor correction......
You don't need to put an apostrophe in front of the dash.
***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Try this:

Select the range you want impacted

From the Excel main menu:
Press the [F5] key....(its the shorcut for<edit<goto )
Click the [special cells] button
ChecK: Blanks
Click the [OK] button

(now all the blank cells are selected)

Type: '-
(that's an apostrophe and a dash...if you just type a dash, Excel will try
to build a formula)

Hold down the [ctrl] key and press the [enter] key
(that will put the dash in every selected cell)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Colin Hayes" wrote:


Hi

In column A , I have some cells which contain text , and others which
are blank.

Is there a formula which will fill the empty ones with a dash (-) ,
whilst leaving the full ones intact?

Hope you can help.



Best Wishes


Colin