Replacements

This tab determines the text to be searched for, or search/replaced.

Load replacement list from file

When checked, search/replace pairs are loaded from a file dynamically at run time - from Excel (.XLS files), Comma Separated Value (.CSV files) or Tab-delimited (.TAB files) formats. The current search type, search location and other options are used for every search/replace pair added. A list can also be imported using an option in the Options menu.

ExcelPipe can handle an unlimited number of replacements - but MS Excel is limited to 65534 rows of data. You can work around this limit by loading multiple files from the command line.

Note: Loading large lists from Excel is very slow - export your list to .CSV or .TAB and then import that instead.

Using these values

Uses the search/replace pairs specified in the grid. Click the [Add] button to add a new row to the end of the grid. To delete rows, first select them and then click [Delete]. To edit a row, click it, and then press [F2], or click the cell a second time. You can [Tab] and [Shift-Tab] through the grid. You can change the search settings for multiple rows simultaneously by first selecting them and then changing the search settings below. You can move rows using drag and drop, and copy rows by dragging and dropping in conjunction with holding the [Ctrl] key down.

Find what

Type the information you want to search for or paste it from the Clipboard. The Find text is limited by MS Excel to be a maximum length of 255 characters. You can right click this field for a popup menu with Cut, Copy, Paste and Clear commands.

Note: You can only search for one line of text at a time. If you wish to use multiple lines, or search using wildcards, see the special characters section.

Searching for multiple lines

Although the edit field can hold multiple lines of text, MS Excel does NOT allow you to search for multiple lines at once (and ExcelPipe cannot get around this limitation). The best way to search for multiple lines is to break them up into several line-by-line or phrase-by-phrase searches.

Replace with

Type the text that you want to use as replacement text or paste if from the Clipboard. Leave the Replace With box empty to delete the Find What box from your document. The Replace text is limited by MS Excel to be a maximum length of 255 characters. You can right click this field for a popup menu with Cut, Copy, Paste and Clear commands.

Look In

• Cells - look in each cell
• Hyperlink addresses - look inside hyperlink addresses. To change the displayed text, use the 'Cells' option above as well
• Shapes - inside the text of shapes and grouped shapes
• Headers - search inside the left, centre and right header of each sheet
• Footers - search inside the left, centre and right footer of each sheet
• Built in properties - inside Subject, Title, Author etc fields
• Custom properties - inside custom properties defined by the user
• Links (OLE and DDE) - inside links to external documents and databases
• Chart Titles - inside the titles of charts. Note - axis labels come from the work sheet itself, so use the Cells option to replace them
• Defined Names - search and replace the name of predefined names (the names of ranges, constants etc).

Match case

Distinguishes between UPPERCASE and lowercase letters. When Match Case is selected, ExcelPipe finds only those instances in which the capitalization matches the text you typed in the Find What box.

Match entire cell contents

Searches for matches where the entire cell has this value, rather than part of the cell.

Start replacing

When you click this button, ExcelPipe will begin making replacements.

Start searching

When you click this button, ExcelPipe will begin searching for the search text. No replacements will be made.