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

[Former Member]

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

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

[Former Member · Accepted solution]

Thanks Neil !