How to substitute text in Google sheets

Configurare noua (How To)

Situatie

This is a method on replacing the text in Google sheets.

Solutie

Open Edit in the menu and select Find and Replace.

When the dialog box appears, enter the text you want to replace in the Find field and the new text you want in the Replace With field.

Next to Search, use the drop-down box to select where you want to find and replace. You can choose All Sheets, This Sheet, or Specific Range.

If you want to review each case before you replace the text, click Find and then Replace. To substitute all text immediately, click Replace All.

Tip solutie

Permanent

Voteaza

(0 din 1 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?