•1 min read•from 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
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.
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 :
EXCEL version : 2016
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel
#pasting
#cell
#text
#line breaks
#rows
#Alt+Enter
#Marches publics
#fix
#manually
#version
#Fourniture de livres
#Excel in French