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 have >100 cells so it's not feasible to do so manually via Alt+Enter

1

1 Answer

You may try the following steps.

1. 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.

2. Right click these cells > Format Cells > Check the box of "Wrap text".

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy