Version: 2.15Updated: 07.12.2023ModificationsVisitors: 967491ImprintFeedbackLiabilityDonation (CHF 10)Created by PFS
Tipps und Tricks rund um den Computertipps_und_tricks_computer
Tips and tricks for your computer
Translate with Google
↑ 2018-01-04  Microsoft Excel: Zeilenumbruch entfernen mit Suchen und Ersetzen 
Problem:
Manchmal hat es in einer Excel-Tabelle Zeilenumbrüche. Wenn man die Tabelle als .txt-Datei exportieren will, dann verteilt sich der Inhalt auf mehrere Zeilen. Wie kann man die Zeilenumbrüche entfernen?
Lösung:
- Dialog 'Suchen und Ersetzen' aufrufen.
- im Feld 'Suchen nach' die ALT-Taste drücken und auf dem Zahlenblock '010' eingeben (unsichtbares Zeichen für Zeilenumbruch.
- im Feld 'Ersetzen durch' irgendetwas eintragen: nichts, Leerzeichen, Bindestrich, usw.
- auf die Schaltfläche 'Alle ersetzen' klicken.
Translate with Google
Link to this page


Advertisement:
QR Code Generator - goqr.me
Apostroph Group - www.apostrophgroup.ch   Apostroph Group - www.apostrophgroup.ch
Translations Proofreading Re-reading
Certified translations Interpreting
 
Advertisement:
Patrick Faeh Services   PC Help - Programs - Translation - Webdesign
Marc Steiger AG
Products and Services for Souvenir, Fashion Accessories, Sports areas and Custom-made productions
Patrick Faeh Services   Absences, Holiday,
Organizer, Plan, Schedule
DateiCommander
JS Classes   JS Classes
Shop For Me - www.shopforme.ch
Patrick Faeh Services   PC Help - Programs - Translation - Webdesign
Patrick Faeh Services   Transfer -
send data per web
AnyDesk - Your desk @ any desk.
Giveaway of the Day
O&O Software -
Patrick Faeh Services   Transfer -
send data per web
Patrick Faeh Services   PC Help - Programs - Translation - Webdesign
Rain jacket, Down jacket, Down gilet
MAC IN A SAC - www.macinasac.ch
Apostroph Group - www.apostrophgroup.ch
Apostroph Group - www.apostrophgroup.ch
Translations Proofreading Re-reading Certified translations Interpreting
Souvenir Swiss - www.souvenir-swiss.ch
komforthaus - The new generation of building - www.komforthaus.eu
Construction cost optimization. We are not specialists. We'll show you what we've learned from experience.
JS Classes   JS Classes
BXU TV. Swiss Business TV channel. - www.bxutv.ch
Storys, Stars, News, Lifestyle and Information. - Produced by Business X Union AG.
komforthaus - The new generation of building - www.komforthaus.eu
Construction cost optimization. We are not specialists. We'll show you what we've learned from experience.
Patrick Faeh Services   PC Help - Programs - Translation - Webdesign
Blue Ink - www.blueink.ch
Blue Ink
www.blueink.ch
Blue Ink: Give wings to your ideas... - Professional translator and writer - Traductrice et rédactrice professionnelle
UFC - Urban Fäh Consulting
Kompetenz in Strategie, General Management und Nachfolge. Situation klären, Marktposition stärken, Nachfolge regeln. Schnell. Professionell. Ergebnisorientiert.
JS Classes   JS Classes
QR Code Generator - goqr.me
TeamViewer for Remote Support
Rain jacket, Down jacket, Down gilet
Outdoor Spirit - My To Go - We Love Camping - www.outdoor-spirit.swiss
Products for all outdoor activities, daily out-of-home consumption, and camping.
QR Code Generator - goqr.me
Patrick Faeh Services   Transfer -
send data per web
Readly - www.readly.com
Readly - www.readly.com
Magazines for every moment.
BXU TV. Swiss Business TV channel. - www.bxutv.ch
Storys, Stars, News, Lifestyle and Information. - Produced by Business X Union AG.
Outdoor Spirit - My To Go - We Love Camping - www.outdoor-spirit.swiss
Products for all outdoor activities, daily out-of-home consumption, and camping.