Find line breaks in Excel
இழை இடுபவர்: CafeTran Trainer
CafeTran Trainer
CafeTran Trainer
நெதர்லாந்து
உறுப்பினர் (2006)
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.)


 
CafeTran Trainer
CafeTran Trainer
நெதர்லாந்து
உறுப்பினர் (2006)
தலைப்பை ஆரம்பித்தல்
Demo Jul 30, 2023

On Mac:

1


 
CafeTran Trainer
CafeTran Trainer
நெதர்லாந்து
உறுப்பினர் (2006)
தலைப்பை ஆரம்பித்தல்
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:

இந்த மன்றத்துக்கான மட்டுறுத்துனர்கள்
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






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 »
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 »