Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

What is the character code for new line break in excel

Tags:

excel

line-breaks

excel-formula

excel-2007

I tried char(10) and char(13) but they don`t work by me. I use Excel 2007 and my task is to replace new lines with intervals

like image 833
Radoslav Ivanov Avatar asked Dec 18 '15 16:12

Radoslav Ivanov

1 Answers

Use CHAR(10) and Turn on Wrap Text option. It should work.

like image 172
vanathaiyan Avatar answered Nov 28 '22 03:11

vanathaiyan
Sign in to Comment

Related questions

Microsoft ACE OLEDB provider throws could not find installable ISAM exception
How can I check for or cancel MULTIPLE pending application.ontime events in excel VBA?
Import txt file with line breaks into Excel
Convert large xlsx file to csv without using phpExcel
Search in xlsx and xls file using java
Parse a Json(with array and objects) and export the data into Excel file in Node.js
Connection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect
Open spreadsheet xml in Excel by default
Excel interop works on machine with Office 2007 but fails on machine with Office 2010
Creating a Workbook with a custom name without saving it to disk
Using VBA to insert and keep images in file - Excel 2013
Subtracting ranges in VBA (Excel)
VBA function to test if cell is conditionally formatted in Excel
Alter the style of all cells with openpyxl
What is the R equivalent for Excel IFERROR?
VBA code to update / create new record from Excel to Access
How to push an operation onto the Excel undo stack?
Recordset always returns -1 (excel VBA)
Prevent the "Update Values:" dialog box from opening every time a cell with a link is modified
File Excel From Apache POI Cant Open by Ms Excel (corrupt)

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!