Hard returns when using &

[tobysdhc]

Hello all,

I am using "&" to link data from cells to build a directory (Column A Phone Number, Column B Ext).

Is it possible to install a built in hard return? I tried putting the hard return (Alt+Enter) in the formula, but that did not work.

In the screen shot below, how do I put a hard return so that the Ext is on its own line? is it possible?

Thanks in advanced

 

[MARK858]

Try

=A1  & " EXT " &  CHAR(10) & B1

and make sure the cell is wrapped.

 

[tobysdhc]

Try

=A1  & " EXT " &  CHAR(10) & B1

and make sure the cell is wrapped.

Unfortunately, no luck.

 

[MARK858]

So what do you want, this?

Book2
	A	B	C	D	E	F
1	123	456				123 EXT 456
Sheet4

Cell Formulas
Range	Formula
F1	F1	=A1 & CHAR(10) & "EXT " & CHAR(10) & B1

if so some description other than just a screenshot would help, not psychic.

 

[tobysdhc]

I apologize, my goal was to have it look like this.

 

[MARK858]

And make sure sure that you wrap the text.

Book2
	A	B	C	D	E	F
1	123	456				123 EXT 456
Sheet4

Cell Formulas
Range	Formula
F1	F1	=A1 & CHAR(10) & "EXT " & B1