Searching all blank row and convert them (-) with multiple data in Excel

[parbatidebnath]

HOW TO SEARCH ALL BLANK ROW AND CONVERT THEM (-) WITH MULTIPLE DATA IN EXCEL*

 

[nazmul_muneer]

Can u provide sample data?

 

[Hui]

You can try this VBA code

[pre]

Sub Replace_Blanks()
Dim c As Range
For Each c In Selection
If c.Value = "" Then c.Value = "-"
Next
End Sub

[/pre]

Then select the range you want to check

Run the code

 

[Debraj]

Hi Parbati,

select the range you want to check


press Alt + E + G + S + K, **(goto Special - Blanks) / Home >Editing > Find & Select > GotoSpecial > Blanks)

Now just write "-" and press Ctlr + Enter..


Its Done..

 

[nazmul_muneer]

Select range

Press Ctrl+H

Make Blank or clean "Find What" text box

Type - in "Replace with"

Click on Replace All