I have two pieces of data in one cell and I want to put a carriage return between them when it is entered into a google sheet and I want the original text to be in there. Does anyone know how to do that?
Question
How do I insert a carriage return between two data pieces in one Google Sheets cell?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+11- Community Manager
Hi
You’d need to hold the Shift button down on your keyboard and press Return button a couple of times to space out the old and new values.
For example:
That would then appear in the Google Sheets spreadsheet like this:
I hope that helps. If I’ve misunderstood what you’re wanting to do here or you encounter any issues on that do let me know!
The Zappy Awards are back
We're celebrating the Zapier builders making AI transformation happen. Winners get a published story on zapier.com, a trophy, $5,000 cash, and a feature at ZapConnect. Nominate yourself or a peer by July 24th, 2026.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.