Multiple Line Texts to a single line??

Hi ! I have a multiple line texts I want to convert it in single line like for Example:

The following contents is to be converted in a single line

contents:

[aaaaaaaa] [bbbbbbb]......so on
[cccccccc] [ddddddd]......so on
[eeeeeeee] [fffffffffff]......so on

Result:

[aaaaaaaa] [bbbbbbb] [cccccccc] [ddddddd] [eeeeeeee] [fffffffffff]....so on


Thanks in advance

Hi mandukes,

If you are talking about the content of a single cell with multiple lines:

Please Login or Register  to view this content.

Otherwise, if you want to concatenate a number of cells, let's say all the content of A1:B3, try this:

Please Login or Register  to view this content.

Cheers, berlan

Hi,

Assuming list is in A1:Bnn then in C1 copied across

Formula:

Please Login or Register  to view this content.

You can find your solution at the link below

http://www.excelforum.com/excel-gene...ml#post3635882

[QUOTE=berlan;3643097]Hi mandukes,

If you are talking about the content of a single cell with multiple lines:

Please Login or Register  to view this content.

Hi Berlan

"=SingleLine" function is not visible in Cell when I call it.

Using office 2013 x64

Regards


Edit : Working absolutely fine!! you are great

Thank you m8