Hi

Maybe:

=REPLACE(A1,FIND("@",A1),0,CHAR(10))

Replace the @ with whatever the specific character is.

Hope this helps!

Richard


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