How to display '#' as blank?

[Former Member]

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 · Accepted solution]

hi,

you can do with vbamacro

by Peter

SAPBEXonRefresh()

Dim c as range

For Each c in resultArea.cells

if c.Value = "#" then c.Value = " "

Next c

or

by Jens (consider to performance)

put in SAPBEXonRefresh()

resultArea.Select

Cells.Replace What:="#", Replacement:=" ", LookAt:=xlPart, _

SearchOrder:=xlByRows,

MatchCase:=False,

SearchFormat:=False, _

ReplaceFormat:=False

hope this helps.

[Former Member · Accepted solution]

Solved, thanks.

[Former Member]

Hi Haito,

See this thread.

Cheers,

Aravindhan