How to find or replace text and numbers on a Excel worksheet | Microsoft

preview_player
Показать описание
Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else. You can include wildcard characters such as question marks, tildes, and asterisks, or numbers in your search terms. You can search by rows and columns, search within comments or values, and search within worksheets or entire workbooks.

Рекомендации по теме
Комментарии
Автор

I want to replace one column from numbers into text, in my case, I want to change the gender variable and give it the text as "Female" of number one and "Male" of number 2...Could you please guide me?

mar
Автор

My laptop is slow cause of the hidden caches memory.
Possible to make a vid how to re-install W10 without losing documents?

s-Trance_
Автор

This video does not show how to replace numbers? I need to replace a certain number, for another. When I type the number in the "find" field, it tells me nothing matches.... which is far from the case. I'm staring at the number right now, lol.

DisneyUpBoilerUp