Jump to content
Business Intelligence & Analytics for Digital Transformation



Recommended Posts


By using Concatenate - we are able to put all the text of different cell in one cell. But it comes up besides each other. I separate it with comma. But I want text of all cell in one cell one below other. Is it possible. 

Eg. Concatenate - gives  -120 hill ave, york on ca, l5b 

I want - 120 hill ave

              york on ca


Link to comment
Share on other sites

Want to add a line break in between each text string?

This is done by entering the CHAR( ) function in between each text string/argument.

CHAR function returns a character specified by a number from 1 to 255. For example, CHAR(10) returns a line break in windows, CHAR(34) returns a ” (double quote), CHAR(64) returns @, etc.

So, by simply adding CHAR(10) in between your formula you can enter a line break. You will need to select WRAP TEXT in order to see each text on a separate line.

Link to comment
Share on other sites

  • 3 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...