How to display '#' as blank?
Some fields are displayed as 'not assigned', and others are displayed as '#', for blank fields in Bex reports? How can I display them as blank? Thanks!
Edwin Harpino replied
you can do with vbamacro
Dim c as range
For Each c in resultArea.cells
if c.Value = "#" then c.Value = " "
by Jens (consider to performance)
put in SAPBEXonRefresh()
Cells.Replace What:="#", Replacement:=" ", LookAt:=xlPart, _
hope this helps.