[Solved] Is there a formula to create cell D1 from A1 .... image example

[lacogada]

Is there a formula to create cell D1 from A1 ?​

 

[shamimarita]

Hello,

You can achieve this by using a formula that inserts a line break between "Top" and "Bottom." In cell D1, enter:

• After that, make sure Wrap Text is enabled for cell D1 (Home tab → Alignment group → Wrap Text).
• This way, the space in A1 will be replaced with a line break, and you’ll see "Top" on the first line and "Bottom" on the second line inside D1.

 

[lacogada]

Thanks very much ... works perfect.

 

[shamimarita]

You are most welcome. Keep exploring Excel with ExcelDemy!