19

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

BruceWayne
  • 22,923
  • 15
  • 65
  • 110
Radoslav Ivanov
  • 209
  • 1
  • 2
  • 3
  • 2
    Possible duplicate of [Turn Excel line break into
    ](http://stackoverflow.com/questions/6116403/turn-excel-line-break-into-br)     – rajah9 Dec 18 '15 at 16:15
  • No it doesnt work. It doesn`t find me Alt + 010, neither Alt + 013, neither 0010, nor 0013, NOR CTRL + J. Any suggestions? – Radoslav Ivanov Dec 18 '15 at 16:18
  • Please try Alt + 0010. – rajah9 Dec 18 '15 at 16:19
  • Nope, is it a setting from somewhere? – Radoslav Ivanov Dec 18 '15 at 16:25
  • The solution from [Turn Excel line break into
    ](http://stackoverflow.com/q/6116403/1652222) worked for me. Provide some more details what exactly you are trying     – ManishChristian Dec 18 '15 at 16:25
  • I try to replace new lines with an interval. I tried everything: from standart dialog box I try to replace Alt + all posible combinations, but it doesn`t work – Radoslav Ivanov Dec 18 '15 at 16:29
  • One thing I found is that sometimes when I do not do it on the first try that I do not clear everything in the find box. Make sure everything is deleted from the box, you will not see anything but it might still have an invisible character. Then hit only ctrl - j, it will appear empty. but it is there. – Scott Craner Dec 18 '15 at 16:32
  • What is an interval? – LocEngineer Dec 18 '15 at 16:32
  • empty space, for instance – Radoslav Ivanov Dec 18 '15 at 16:35
  • If you're trying CTRL+J, you should be able to use `ALT+ENTER`. But you're asking for the character, so maybe that's not helpful...A note also, if you are using `CHAR(10)` (and probably other options), make sure Text wrapping is turned on for that cell. Otherwise you won't see the line break. – BruceWayne Jan 17 '18 at 02:49
  • 3
    Wait - you're trying to *replace* new line breaks. Does this not work? `=SUBSTITUTE(A1,CHAR(10)," ")` . Where `A1` is a cell with text, and line breaks? If not, can you please show us the data, what's it look like? – BruceWayne Jan 17 '18 at 02:57
  • This comment should be in the answer tab.. (: – p._phidot_ Jul 23 '18 at 06:30

2 Answers2

22

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

vanathaiyan
  • 935
  • 1
  • 10
  • 19
0

Try using the [Alt] + [Enter] key. This will create a new line feed in the cell.

user716255
  • 352
  • 1
  • 6
  • 18