Skip to Content

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

Any Function that let the other Concatenated Object comes to Next Line ?

Hi,

I have variable with three Objects that are concatenated like following , and the values are coming from a prompt using User Response.

=<Site Name>+" "+<Country Name>+" "+<Address>  which bascially looks SiteName CountryName Address

but i wanna show the above objects in different lines but in one cell , like ..

=<Site Name>+" "+

<Country Name>+" "+

<Address>

so basically wanna show like

SiteName

CountryName

Address

In one cell , is there any function which basically make the next object go to second line ?

Former Member
replied

Yes; use the CHAR(13) function. This is the ascii instruction for a carriage feed.

In your example it would be:

=[Site Name]+char(13)+[Country Name]+char(13)+[Address]

HTH

NMG

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question