How to strart new line with in concatenate formula 1

[aasayeed]

I am using the concatenate formula in one of the cells to concatenate information from three columns.

=CONCATENATE("Vehicle:-E8,","Article:-F8,","Animal:-G8,")

I want the information from each column to start on a new line in the concatenated column.

What is the line seprator in Excel and how can I use in the above fromula.

 

[xlbo]

use Char(10) - but the cell MUST be set to Wrap Text

="This" & char(10) & "Shows" & char(10) & " Multiple Lines"

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[aasayeed]

Dear XLBO ...
Thanks a lot for your help.

Your suggestion would ease my work .

Regards

Sayeed