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

="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

Try something like this:

With
A1: The amount in US currency is $1,500.00.

This formula inserts a carriage return before the Dollar Sign:
E1: =SUBSTITUTE(A1,"$",CHAR(10)&"$")

Note_1: You'll need to expand the column width of Col_E and turn on text wrap.
Noe_2: 10 is the ASCII code for a carriage return.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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

Thanks to Ron and Dave. I'm working with German software and don't speak a
word (a part from ordering beer) so I'm sorry if I'm asking daft questions.

Thanks a million.

EB

"Ron Coderre" wrote:

Try something like this:

With
A1: The amount in US currency is $1,500.00.

This formula inserts a carriage return before the Dollar Sign:
E1: =SUBSTITUTE(A1,"$",CHAR(10)&"$")

Note_1: You'll need to expand the column width of Col_E and turn on text wrap.
Noe_2: 10 is the ASCII code for a carriage return.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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

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