Skip to main content
Question

How do I insert a carriage return between two data pieces in one Google Sheets cell?

  • July 17, 2024
  • 1 reply
  • 11 views

Forum|alt.badge.img

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?

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7811 replies
  • July 18, 2024

Hi @AdamZap! 👋

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:
58f05ae427a1944a70d548016ae2cc72.gif

That would then appear in the Google Sheets spreadsheet like this:
fb9c500b5d0963e800e05a18414251b7.png

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!