Skip to Content
avatar image
Former Member

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 11, 2014 at 03:49 PM

    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

    Add comment
    10|10000 characters needed characters exceeded