Technische forums » Office applications »
Find line breaks in Excel
De persoon die dit onderwerp heeft geplaatst: Hans Lenting
Hans Lenting
Hans Lenting
Nederland
Lid 2006
Duits naar Nederlands
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
Nederland
Lid 2006
Duits naar Nederlands
ONDERWERPSTARTER
Demo Jul 30, 2023

On Mac:

1
 
Hans Lenting
Hans Lenting
Nederland
Lid 2006
Duits naar Nederlands
ONDERWERPSTARTER
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:

Moderator(en) van dit forum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

Find line breaks in Excel






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »