Hard returns when using &

tobysdhc

Board Regular
Joined
Aug 11, 2015
Messages
54
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. Web
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?

1601652689478.png


Thanks in advanced
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
14,072
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Try
Excel Formula:
=A1  & " EXT " &  CHAR(10) & B1
and make sure the cell is wrapped.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
14,072
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
So what do you want, this?

Book2
ABCDEF
1123456123 EXT 456
Sheet4
Cell Formulas
RangeFormula
F1F1=A1 & CHAR(10) & "EXT " & CHAR(10) & B1


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

tobysdhc

Board Regular
Joined
Aug 11, 2015
Messages
54
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. Web
I apologize, my goal was to have it look like this.

1601655388475.png
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
14,072
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
And make sure sure that you wrap the text.
Book2
ABCDEF
1123456123 EXT 456
Sheet4
Cell Formulas
RangeFormula
F1F1=A1 & CHAR(10) & "EXT " & B1
 

Watch MrExcel Video

Forum statistics

Threads
1,130,381
Messages
5,641,816
Members
417,239
Latest member
AymericA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top