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

Hello,

You can achieve this by using a formula that inserts a line break between "Top" and "Bottom." In cell D1, enter:
1758548184798.png
  • 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.
 

Online statistics

Members online
1
Guests online
195
Total visitors
196

Forum statistics

Threads
468
Messages
2,092
Members
7,094
Latest member
hi888itcom
Back
Top