Concatenate

[Kashmira]

Hi

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

              l5b

[Saurabh Jain]

You already know that you need a line between the strings 

u need to add line in between 

Line with come with char(10)

[Saurabh Jain]

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.

[Kashmira]

Thanks. Inused this and it worked very welll.

Thanks

Kashmira