1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Excel pasting text into multiple rows instead of line breaks in one cell

Our take

Are you encountering an issue in Excel where text pasted from multiple lines appears in separate rows instead of remaining in a single cell with line breaks? This common challenge can disrupt your workflow, especially when dealing with numerous rows. Fortunately, there’s an easy solution that allows you to achieve the desired result, keeping all text in one cell while ensuring the second line appears underneath, just like using Alt+Enter. Let’s explore a practical method to streamline this process for all your data at once.

Hi, I’m copying text that looks like this:

thème Marches publics :
Fourniture de livres actualisés (2022–2026 minimum)

But when I paste into Excel, it splits into two different rows instead of staying in the same cell with a line break.

https://preview.redd.it/21v9ojbi4jwg1.png?width=770&format=png&auto=webp&s=93a1c2addabadaa2e21108aca028f059b08440d8

I want each item to stay in one cell, with the second line appearing underneath (like Alt+Enter).

I have many rows, so doing it manually isn’t practical.

What’s the easiest way to fix this for all rows at once?

(Excel in French if that matters)

Desired result :

https://preview.redd.it/zanoihqq4jwg1.png?width=687&format=png&auto=webp&s=96fa2f569725fdaef6dd5d1d8577b0b85a09950a

EXCEL version : 2016

submitted by /u/No_Wolverine_9702
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Related Articles

Tagged with