="You owe us:" & char(10) & text(a1,"$#,##0.00")

Char(10) is the same as alt-enter when typing text.

Excel Believer wrote:

Hi,

Am trying to create a formula which inserts a carriage return at a specific
symbol in a text string. Is this possible?

Thanks,

EB

--

Dave Peterson