Brought to you by:

Hi Reader,

Welcome to the Google Sheets Tips newsletter #330, your Monday morning espresso, in spreadsheet form!

Where do these tips come from?

Often, they come from readers' questions that will be helpful to share. I'll also share compelling tips I find online (lately LinkedIn has been a good source). I've often found great tips in Excel groups, for example, that can be applied equally as well to Sheets.

And sometimes, I simply stumble across a tip in the course of my own work, such as this week. When I pasted a list of URLs into my Sheet, it put them all in a single cell. I had to separate them into their own cells. See how I did it below.

Brought to you by: ProjectionLab Take a Break from Google Sheets We get it. We love Sheets too. But spreadsheets have their limitations. When they couldn’t bring our financial plan to life, we built a tool that could. ProjectionLab combines beautiful visuals with real-time simulations to make financial planning intuitive, powerful, and fun. Join thousands of spreadsheet lovers who use ProjectionLab to: Visualize the future with interactive charts and plots that turn finances into insights. Plan for and map out goals, like early retirement. Test strategies and decisions using powerful scenario modeling. Dive deep with Historical Backtesting, Monte Carlo Simulations, Sankey Cash-Flow Visualizations, detailed tax estimation, and more. It’s everything Sheets can’t be. Explore ProjectionLab today

➜ News

I.
​The Apps Script OAuth consent screen is getting an update to become more granular. Users will be able to selectively grant or refuse access to each service the script requests.

​Read more >>​

➜ Sheets Tip #330: How to deal with multiple lines in a single cell?

I recently pasted the contents of my clipboard into my Sheet and instead of pasting across multiple rows, all the data was inside a single cell.

Here's an example:

Now, it's often possible to solve this by doing a PASTE-SPECIAL operation instead of a standard paste.

In a blank cell, right click to bring up the menu and then select:

Paste Special > Values only

Often, this will spread the data across multiple rows:

But, should you find yourself with multi-line data inside a single cell, then use this formula to split it out:

This outputs the data across columns.

Wrap it with a TRANSPOSE function to change to a single column with multiple rows:

In our Sheet, it looks like this:

N
i
c
e
!

If you enjoyed this newsletter, please forward it to a friend who might enjoy it.

Have a great week!

Cheers,
Ben

P.S. Maybe Google should add this?? 😂