concatenate & enter (2003 SP3)

steveh · Post by **steveh** » 04 Nov 2010, 14:52

Good afternoon

Is it possible, and if so how, to insert a carriage return into a concatenate formula?

TIA

rory · Post by **rory** » 04 Nov 2010, 15:00

Do you mean:
="hello"&char(10)&"Steve"
?

Post by **Leif** » 04 Nov 2010, 15:08

Using it in a formula, I find I need to format the cell E2 to wrap-text, otherwise it looks like the lower example:

x.jpg

steveh · Post by **steveh** » 04 Nov 2010, 15:35

Cheers Both

I stupidly tried to put alt10 into the formula

Post by **HansV** » 04 Nov 2010, 15:49

You can insert Alt+Enter into a quoted string in a formula:

x384.png

The line break in the string in the formula bar was entered by pressing Alt+Enter.

Eileen's Lounge