Inserting dashes into blank cells

thekingoflondon

Board Regular
Joined
Sep 22, 2005
Messages
67
Hi I have a very large spreadsheet, some of the cells in it are completely blank, and I wish to change the blank cells so that they instead have a dash in them. Is there is quick way of achieving this?

:biggrin:
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi

One way:

1.Select the range that you want to apply dashes to (including non-blank cells)
2. Go Edit>Goto>Special Button>Check Blanks checkbox, click OK
3. Type: ="-" and confirm with Ctrl+Enter (ie not just Enter)

Hope this helps!
 

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,803
Office Version
  1. 365
Platform
  1. Windows
Hi

In a blank cell enter a dash. Copy that cell. Then hit F5 and click 'Special'.

Choose Blanks from the options and 'Ok'. Paste the dash in the blank cells.

Regards,
Jon
 

Tyler_Dirton

Board Regular
Joined
Oct 24, 2006
Messages
50
The easiest way would be to select the range of cells, and do a Find/Replace.

Finding " " and replacing with "-"
 

Watch MrExcel Video

Forum statistics

Threads
1,113,795
Messages
5,544,337
Members
410,603
Latest member
rseckler
Top