Leerzeichen zwischen Zeichen und Zahlen in Excel entfernen

PDF herunterladen

unter Mitarbeit von wikiHow Staff

PDF herunterladen

Dieses wikiHow zeigt dir, wie du unerwünschte Leerzeichen aus Zellen in einer Excel-Tabelle entfernen kannst.

Methode 1

Methode 1 von 2:

Suchen und Ersetzen verwenden

PDF herunterladen

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/86\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-1-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-1-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/86\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-1-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Wenn du zum Beispiel die Leerzeichen von C2 bis C30 entfernen möchtest, markiere diese Zellen.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e7\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-2-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-2-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e7\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-2-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fc\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-3-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-3-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fc\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-3-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a4\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-4-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-4-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a4\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-4-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Nun wird ein Dialogfeld eingeblendet.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/18\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-5-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-5-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/18\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-5-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f7\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-6-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-6-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f7\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-6-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-6-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Achte darauf, dass du sie nur einmal drückst.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/8b\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-7-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-7-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8b\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-7-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Die ist der zweite Button am unteren Rand des Fensters. Die Leerzeichen werden nun aus den ausgewählten Zellen entfernt. Anschließend erscheint ein Pop-up-Fenster, das dir mitteilt, wie viele Leerzeichen entfernt wurden.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/94\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-8-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-8-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/94\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-8-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Werbeanzeige

Methode 2

Methode 2 von 2:

Die Ersetzen-Funktion verwenden

PDF herunterladen

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d5\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-9-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-9-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d5\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-9-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

1
Klicke auf die oberste Zelle in einer leeren Spalte. Die Zelle muss sich in der gleichen Zeile befinden wie die erste Zeile der Daten in der Spalte mit den Leerzeichen.
- Wenn du z.B. Leerzeichen aus der Spalte C entfernen möchtest und die erste Datenzeile von C in Zeile 2 (C2) liegt, klicke auf die zweite Zelle in deiner leeren Spalte (z.B. E2, F2, G2, etc.).
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/33\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-10-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-10-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/33\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-10-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

^{[1]
X
Forschungsquelle}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c4\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-11-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-11-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c4\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-11-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

3
Klicke auf das erste Feld in der Spalte mit Leerzeichen. Wenn du zum Beispiel alle Leerzeichen aus der Spalte C entfernen möchtest, klicke auf das erste Feld (z.B. C2) in der Spalte, das nicht der Titel ist.
- Wenn du auf die Zelle C2 geklickt hast, sollte die Formel nun wie folgt aussehen: =Substitute(C2 .
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d2\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-12-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-12-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d2\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-12-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Die Zelle sollte nun wie folgt aussehen: &# 61;Substitute(C2, .
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c1\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-13-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-13-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c1\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-13-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

5
Tippe " ", ein. Ein Leerzeichen befindet sich zwischen den beiden Anführungszeichen - das ist wichtig.
- Die Formel sollte nun wie folgt aussehen: =Substitute(C2," ", .
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/cf\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-14-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-14-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cf\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-14-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

6
Tippe ”” ) ein. Dieses Mal befindet sich KEIN Leerzeichen zwzischen den beiden Anführungszeichen.
- Die Formel sollte nun wie folgt aussehen: =Substitute(C2,” “,””) .
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/96\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-15-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-15-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/96\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-15-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

7
Drücke auf die Tasten ↵ Enter oder ⏎ Return . Du wirst nun den Inhalt der ausgewählten Zelle (C2, in diesem Beispiel) ohne Leerzeichen in der neuen Spalte sehen.
- Wenn C2 zum Beispiel w ww . wikih ow .com enthält, dann sieht deine neue Zelle nun so aus: www.wikihow.com .
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4f\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-16-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-16-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4f\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-16-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Die Zelle sollte nun hervorgehoben sein.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/43\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-17-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-17-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/43\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-17-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-17-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Die Daten aus jeder entsprechenden Zelle werden nun in deiner neuen Spalte ohne Leerzeichen erscheinen.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fa\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-18-Version-2.jpg\/v4-460px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-18-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fa\/Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-18-Version-2.jpg\/v4-728px-Remove-Spaces-Between-Characters-and-Numbers-in-Excel-Step-18-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Deine neuen Daten ohne Leerzeile befinden sich nun am richtigen Ort.

Werbeanzeige

[1]

Anmelden

Leerzeichen zwischen Zeichen und Zahlen in Excel entfernen

Vorgehensweise

Suchen und Ersetzen verwenden

Die Ersetzen-Funktion verwenden

Verwandte wikiHows

Referenzen

Über dieses wikiHow

War dieser Artikel hilfreich?

Verwandte Artikel

Melde dich für den kostenlosen wikiHow Newsletter an!

Folge uns

Teilen

Explore Categories