What is the character code for new line break in excel

0 votes
I tried char(10) and char(13) but didn't work. I use Excel 2007 and my objective is to replace new lines with intervals. Can someone please help me with this?
Dec 26, 2022 in Others by Kithuzzz
 • 38,010 points • 371 views

1 answer to this question.

0 votes

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

answered Dec 27, 2022 by narikkadan
 • 63,420 points

Related Questions In Others

0 votes
0 answers

What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
 • 38,010 points • 215 views
0 votes
1 answer

VBA code help - Add a line for each missing date with the start and end date defined in a cell

Try this: Sub FillDates() Dim ...READ MORE

answered Jan 24, 2023 in Others by narikkadan
 • 63,420 points • 663 views
0 votes
1 answer

What is the shortest formula in excel to covert text date format e.g. 17 Jan, 2023 into regular date format like 1/17/2023?

The SUBSTITUTE() method can be used to ...READ MORE

answered Jan 30, 2023 in Others by narikkadan
 • 63,420 points • 376 views
0 votes
1 answer

Issues with a VBA code for excel that takes the geolocation info (longitude, latitude, altitude) from a set of files in a folder

SourceFolder is an object that only understands ...READ MORE

answered Mar 21, 2023 in Others by Kithuzzz
 • 38,010 points • 383 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
 • 63,420 points • 989 views
0 votes
1 answer

Excel Formula which places date/time in cell when data is entered in another cell in the same row

Here's how to accomplish things in another ...READ MORE

answered Dec 11, 2022 in Others by narikkadan
 • 63,420 points • 829 views
0 votes
1 answer

Automatically adding the date/time to a cell when another cell is updated AND clearing it when this cell is empty

You are looking for an IsEmpty check in your ...READ MORE

answered Jan 26, 2023 in Others by narikkadan
 • 63,420 points • 299 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
 • 13,670 points • 1,478 views
0 votes
1 answer

In MS Excel what formula can be used to calculate growth when CAGR for the period is already given?

If those are true CAGR's, then just ...READ MORE

answered Nov 20, 2022 in Others by narikkadan
 • 63,420 points • 539 views
0 votes
1 answer

What is the better API to Reading Excel sheets in java - JXL or Apache POI

Here are the things where both APIs ...READ MORE

answered Oct 9, 2022 in Others by narikkadan
 • 63,420 points • 2,727 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.