Cómo buscar y reemplazar en Excel usando una PC o Mac

Descargar el PDF

Coescrito por Personal de wikiHow

Descargar el PDF

Este wikiHow te enseñará cómo buscar cadenas de texto y reemplazarlas en Microsoft Excel para Windows o macOS.

Método 1

Método 1 de 2:

Windows

Descargar el PDF

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/20\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-1.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/20\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-1.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-1.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Normalmente puedes abrirlo desde la sección Todas las aplicaciones del menú

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/0\/07\/Windowsstart.png","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/07\/Windowsstart.png\/30px-Windowsstart.png","smallWidth":460,"smallHeight":460,"bigWidth":30,"bigHeight":30,"licensing":"<div class=\"mw-parser-output\"><p>html\n<\/p><\/div>"}

.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/67\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/67\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Se abrirá en Excel.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/52\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-3.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/52\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-3.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-3.jpg","smallWidth":460,"smallHeight":341,"bigWidth":728,"bigHeight":540,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Es el ícono de los binoculares ubicado en la esquina superior derecha de Excel. Aparecerá una lista desplegable..
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fb\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-4.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fb\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-4.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-4.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Es el primer elemento de la lista desplegable. Se abrirá la ventana Buscar y reemplazar .
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/21\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-5.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/21\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-5.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-5.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Está en la parte superior de la ventana emergente.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/09\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-6.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/09\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-6.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-6.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Asegúrate de no ingresar espacios innecesarios ya que estos podrían modificar el resultado de la búsqueda.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/aa\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-7.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/aa\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-7.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-7.jpg","smallWidth":460,"smallHeight":341,"bigWidth":728,"bigHeight":540,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Es el texto que reemplazará al que habías ingresado en el primer campo en blanco.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/89\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-8.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/89\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-8.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-8.jpg","smallWidth":460,"smallHeight":341,"bigWidth":728,"bigHeight":540,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

En esta pantalla encontrarás opciones como distinguir mayúsculas de minúsculas, buscar solamente texto que tenga un formato específico, buscar dentro de fórmulas, etc. Si solo quieres reemplazar un texto estándar por otro texto estándar, puedes saltar este paso.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1f\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-9.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1f\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-9.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-9.jpg","smallWidth":460,"smallHeight":350,"bigWidth":728,"bigHeight":554,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Elige Reemplazar todo si quieres que se realicen automáticamente los reemplazos a lo largo de todo el documento o Reemplazar si quieres que se realice solo el primer reemplazo. En este último caso, deberás hacer clic en Buscar siguiente para ver la próxima coincidencia y seleccionar otra vez Reemplazar .

Anuncio

Método 2

Método 2 de 2:

macOS

Descargar el PDF

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/26\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-10-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-10-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/26\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-10-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Normalmente puedes abrirlo desde la carpeta Aplicaciones o desde el Launchpad.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/8d\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-11-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-11-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8d\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-11-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Se abrirá en Excel.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4c\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-12-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-12-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4c\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-12-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Está en la parte superior de la pantalla.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fe\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-13-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-13-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fe\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-13-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fe\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-14-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-14-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fe\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-14-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/54\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-15-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-15-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/54\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-15-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Asegúrate de no ingresar espacios innecesarios ya que estos podrían modificar el resultado de la búsqueda.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/cc\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-16-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-16-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cc\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-16-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Es el texto que reemplazará al que habías ingresado en el primer campo en blanco.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3f\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-17-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-17-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3f\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-17-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-17-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Elige Reemplazar todo si quieres que se realicen automáticamente los reemplazos a lo largo de todo el documento o Reemplazar si quieres que se realice solo el primer reemplazo. En este último caso, deberás hacer clic en Buscar siguiente para ver la próxima coincidencia y seleccionar otra vez Reemplazar .

Anuncio

Iniciar sesión

Cómo buscar y reemplazar en Excel usando una PC o Mac

Pasos

Windows

macOS

wikiHows relacionados

Acerca de este wikiHow

¿Te ayudó este artículo?

Artículos relacionados

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

Compartir

Artículos destacados

Tendencias de tutoriales

Artículos destacados

Vídeos destacados

Artículos destacados

Artículos destacados

Artículos destacados

Explore Categories