Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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!

replied

hi,

you can do with vbamacro

Need to display "-" instead of "#" for blanks

Replace the default u0091#u0092 in BEx

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.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question