Carriage Return in Concatenate formula

[jdh17]

I have many address books of hundreds of records that I have to do an odd conversion on. Basically, I need to merge 3 cells into 1 cell that includes multiple lines. I figured the easiest way to do this would be with a concatenate formula including carriage returns, but as of yet I've been unable to find a good way to do this.

Basically...
if A1 = John Smith
A2 = 123 Fake St.
A3 = Anytown, USA

I would like B1 to equal:
John Smith
123 Fake St.
Anytown, USA

Is there a good formula or macro to implement this????

Thanks in advance.

jdh

 

[SkipVought]

hi,
[tt]
=A1&Char(10)&A2&Char(10)&A3
[/tt]
Format with Wrap

Skip,
[sub]
[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE! [/sub]