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?
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.
Userlevel 7
+11
- Community Manager
- 5790 replies
-
18 July 2024
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.