You manage the office of a used car business. You have been asked to prepare the inventory list for a big annual sale. Simultaneously replace all instances of the text "Pickup" with the text "Truck".

Explanation/Reference: Simultaneously replace all instances of the text "Pickup" with the text "Truck". 1. On the Home tab, in the Editing group, click Find & Select, and then click Replace. 2. In the Find and Replace dialog box, type 'Pickup' in the Find what box. 3. Type…

Manage data cells and ranges

Question

You manage the office of a used car business. You have been asked to prepare the inventory list for a big annual sale. Simultaneously replace all instances of the text "Pickup" with the text "Truck".

Explanation

Explanation/Reference: Simultaneously replace all instances of the text "Pickup" with the text "Truck".

On the Home tab, in the Editing group, click Find & Select, and then click Replace.
In the Find and Replace dialog box, type 'Pickup' in the Find what box.
Type 'Truck' in the Replace with box.
Click Replace All.
Click OK.

Topics

#find and replace#text substitution#worksheet editing

Community Discussion

No community discussion yet for this question.

Full 77-727 Practice