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?
Page 1 / 1
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.