💻 Software
How to enter a carriage return in an Excel file
Fresh7 days ago
Mar 15, 202661385 viewsConfidence Score0%
0%
Problem
How do you enter a carriage return or in a worksheet cell manually ? I'm not talking about a line feed or . I've seen this in a file and the carriage return had a very weird effect on the cell contents, but I can't reproduce it manually. UPDATE There are very good answers about how to enter a line …
Error Output
=A1&CHAR(13)&A2 'Then copy cell + paste values only back again.
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to enter a carriage return in an Excel file
Low Risk
Found here: Method 1 - Cell Wrapping Often you only need to set the cell to wrap text, and you can set the width of the cell to whatever is desired. Choose Format Cells, Alignment tab, and check Wrap text. The result is: Method 2 - Insert a Return T…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix