Cómo eliminar espacios entre caracteres y números en Excel

Descargar el PDF

Coescrito por Personal de wikiHow

Descargar el PDF

Este wikiHow te enseñará cómo eliminar los espacios no deseados de las celdas en una hoja de cálculo de Excel.

Método 1

Método 1 de 2:

Usar "Buscar y reemplazar"

Descargar el PDF

{"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>"}

Por ejemplo, en caso de que quieras eliminar los espacios desde C2 hasta C30, selecciona esas celdas.
{"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>"}

Aparecerá un cuadro de diálogo.
{"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>"}

Asegúrate de presionarla solo una vez.
{"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>"}

Es el segundo botón en la parte inferior de la ventana. Se eliminarán los espacios de las celdas que hayas seleccionado. Aparecerá un mensaje emergente, informándote de cuántos espacios han sido eliminados.
{"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>"}

Anuncio

Método 2

Método 2 de 2:

Usar la función "Sustituir"

Descargar el PDF

{"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
Haz clic en la celda superior de una columna en blanco. La celda deberá estar en la misma fila que la primera línea de datos en la columna con los espacios.
- Por ejemplo, en caso de que quieras eliminar los espacios de la columna C, y la primera fila de datos en C se encuentra en la fila 2 (C2), haz clic en la segunda celda de la columna en blanco (por ejemplo, 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
Fuente de investigación}
{"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
Haz clic en la primera celda de la columna con espacios. Por ejemplo, si quieres eliminar todos los espacios de la columna C, haz clic en el primer cuadro (C2) en la columna que no tenga el título.
- En caso de que hagas clic en la celda C2, la fórmula tendrá este aspecto =Sustituir(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>"}

La celda tendrá este aspecto: &# 61;Sustituir(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
Escribe " ", . Hay un espacio entre los dos grupos de comillas. Esto es importante.
- La fórmula tendrá este aspecto: =Sustituir(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
Escribe "" ). Esta vez, NO habrá espacios entre los grupos de comillas.
- La fórmula ahora tendrá este aspecto: =Sustituir(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
Presiona ↵ Enter o Atrás . En la nueva columna, aparecerán los contenidos de la celda que hayas seleccionado (la C2, en este ejemplo) pero sin los espacios.
- Por ejemplo, en caso de que C2 tuviera el texto w ww . wikih ow .com , la celda ahora tendrá el mensaje 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>"}

Se seleccionará la celda.
{"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>"}

Los datos de cada celda correspondiente aparecerán sin espacios en la columna nueva.
{"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>"}

Los datos sin espacios estarán en su lugar.

Anuncio

[1]

Iniciar sesión

Cómo eliminar espacios entre caracteres y números en Excel

Pasos

Usar "Buscar y reemplazar"

Usar la función "Sustituir"

wikiHows relacionados

Referencias

Acerca de este wikiHow

¿Te ayudó este artículo?

Artículos relacionados

¡Suscríbete al boletín gratuito de wikiHow!

Síguenos

Compartir

Explore Categories