https://search.proz.com/forum/office_applications/363166-find_line_breaks_in_excel.html

Find line breaks in Excel
Autor de la hebra: Hans Lenting
Hans Lenting
Hans Lenting
Países Bajos
Miembro 2006
alemán al neerlandés
Jul 30, 2023

In Excel for Windows you press Ctrl+J to enter ASCII 10.

In Excel for Mac ... you have to press Shift+Ctrl+Alt to insert a line break in the Find and Replace dialogue box!

(Note that in both cases you will only see a white space in the dialogue box.)


 
Hans Lenting
Hans Lenting
Países Bajos
Miembro 2006
alemán al neerlandés
PERSONA QUE INICIÓ LA HEBRA
Demo Jul 30, 2023

On Mac:

1


 
Hans Lenting
Hans Lenting
Países Bajos
Miembro 2006
alemán al neerlandés
PERSONA QUE INICIÓ LA HEBRA
Oops Jul 30, 2023

Hans Lenting wrote:

On Mac:

1


All spaces are replaced.

So one has to replace normal spaces with a unique character first.



[Edited at 2023-07-30 11:27 GMT]


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Find line breaks in Excel






Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »