StarOffice™ 5.2 Calc Handbook

Using the Find and Replace Features

Since we have been looking at ways to enhance the look of your Calc spreadsheets, it makes sense to also take a look at some of the features that will assist you as you edit and fine-tune your spreadsheets. A very useful tool is the Find feature. It allows you to find a text or numeric string anywhere in your spreadsheet.

And if you wish to search for a particular item and then replace it, the Find feature has you covered. You can even search for items using a set of wildcard and placeholder characters that allows you to search for items by using a portion of a text or numerical string as the search string.

To start the Find feature, click the Find tool on the Main toolbar, or select Edit, then Find and Replace. ...