Within a cell, replace multiple lines with one line

[johndrake]

Within a cell, if you have the following

-foo1 ab1
-foo2 ab2
-foo3 ab3

How would you replace the carriage return line feed to get this in the cell, instead:

-foo1 ab1 -foo2 ab2 -foo3 ab3

Instead of the contents being on multiple lines, it is on one line of the cell

 

[SkipVought]

Hi,
[tt]
=SUBSTITUTE(A1,CHAR(10)," ")
[/tt]

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[johndrake]

Hi Skip,

Thanks! Works like a charm.

-Joe