Good all the time of day. File *.xls , in some cells, transfer to another line. How to replace the characters \r\n spaces? Any method of the decision which is the simplest interests.

  • Need to replace all rn? External means go (program, script)? - Alexey Kotov
  • one
    find rn replaced by "space" (empty space) or are you not talking about it? - Malus
  • I do not know who changed my subject heading, and my question ... in some cells there are entries in 2/3 lines: example
  • If in VBA, then you can go through all the cells and replace vbCrLf with a space. Now Excel is not at hand, I can not write and check .. Maybe someone will pick up? :) - Surendil

3 answers 3

Change the hyphen character to a space:

 =ПОДСТАВИТЬ(A1;СИМВОЛ(10);" ")
  • Thanks for the answer !!! Dear, Sunday - Day of Rest - sergey

Cell format - Alignment - Word wrap to remove the check

  • and there is no separation ... super. Is there a way to do the same with separation? - sergey

In the menu Excell there is a submenu replacement.