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
  1. {"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.
  2. {"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>"}
  3. {"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>"}
  4. {"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.
  5. {"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>"}
  6. {"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.
  7. {"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.
  8. {"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
  1. {"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>"}
    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.).
  2. {"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]
  3. {"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>"}
    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 .
  4. {"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, .
  5. {"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>"}
    Hay un espacio entre los dos grupos de comillas. Esto es importante.
    • La fórmula tendrá este aspecto: =Sustituir(C2," ", .
  6. {"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>"}
    ). Esta vez, NO habrá espacios entre los grupos de comillas.
    • La fórmula ahora tendrá este aspecto: =Sustituir(C2," ","") .
  7. {"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>"}
    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 .
  8. {"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.
  9. {"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.
  10. {"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

wikiHows relacionados

Cómo
cambiar minúsculas por mayúsculas en Excel
Cómo
recuperar un archivo Excel corrupto
Cómo
cambiar una coma por un punto en Excel
Cómo
calcular el coeficiente de variación en Excel
Cómo
desbloquear una hoja protegida de Excel
Cómo combinar columnas en Excel sin perder datos
Cómo
tachar texto en Excel
Cómo
abrir un archivo de Excel protegido con contraseña
Cómo
insertar imágenes en Excel que se ajusten automáticamente al tamaño de las celdas
Cómo
combinar celdas en Excel
Cómo
insertar una tabla de Excel en Word
Cómo
usar el número pi en Excel
Anuncio

Referencias

  1. ↑ https://exceljet.net/excel-functions/excel-substitute-function

Acerca de este wikiHow

En otros idiomas
Esta página ha recibido 71 497 visitas.

¿Te ayudó este artículo?

Anuncio