Excel: Alt + Enter for Multiple Cells
I Would Like to Change the First Table into a Wrap Texted Version of Numbers & (Xxx), Making Two Lines in Each Cell. What Is the Best Option for This, as I...
I would like to change the first table into a wrap texted version of numbers & (xxx), making two lines in each cell. What is the best option for this, as I have >100 cells so it's not feasible to do so manually via Alt+Enter
1 Answer
You may try the following steps.
Using formula "
=SUBSTITUTE(RC[-3],"(",CHAR(10)&"(")" to add Line Break before the the left bracket. Then pull down and pull right to apply the formula to all cells with data.Right click these cells > Format Cells > Check the box of "Wrap text".
Sarah Jenkins is a veteran tech journalist with over 12 years of experience covering artificial intelligence, mobile innovations, and digital ethics. Her insights have appeared in leading technology publications worldwide.
