LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 465
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
eliminating empty cells from chart area financeman500 Charts and Charting in Excel 1 February 22nd 06 04:41 PM
Ignoring empty cells beeo Excel Discussion (Misc queries) 3 September 8th 05 09:57 AM
Display empty cells botany_girl Excel Discussion (Misc queries) 1 July 19th 05 05:51 PM
Counting empty cells within a range of cells Rosehill - ExcelForums.com New Users to Excel 2 May 2nd 05 08:53 AM
Counting empty cells within a range of cells Rosehill - ExcelForums.com New Users to Excel 0 April 7th 05 12:47 AM


All times are GMT +1. The time now is 08:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"