A List and Replace Tool for Microsoft(R) Excel(R) Based Files

ToolSleuth, LLC has released PhraseSwapper v1.1, a tool to list and replace any of the text and words of a Microsoft Excel based file. It lists all readable text and exchanges any of these items with an alternate from any language or character set.

[USPRwire, Tue Jan 26 2010] ToolSleuth, LLC has released PhraseSwapper v1.1, a tool to list and replace any of the text and words of your Microsoft Excel based file. The tool is useful to cleanup, re-purpose, translate, or discover file content. It lists all readable text acquired from cells, formulas, comments, drawing shapes, charts, conditional formats, data validation, tab names and headers/footers. You can then exchange one or more of the original items from an alternate list that you make using any language or character set.

Three steps are used to transform your files: (1) An Acquire step to gather all text and merge it into a list (the Library); (2) An Assign Alternate step that allows you (or your translator) to create one or more listings of alternate phrases; and finally, (3) A Swap step that exchanges the originals with the alternates.

PhraseSwapper searches all of the places that text can be found while ignoring pure numerical results and constants. You may also select other conditions and locations to ignore. This tool will not examine any dialogs, macros or code attached to the project. PhraseSwapper respects the protections in place for protected projects, worksheets and workbooks.

PhraseSwapper works with files or templates created using Microsoft Excel XP, Microsoft Excel 2003, or Microsoft Excel 2007. PhraseSwapper runs on Microsoft Windows(R) operating systems only.

ToolSleuth, LLC has provided desktop and web-based solutions for Multinational Sales, Marketing, Design/Build, Design/Manufacture and Energy Services organizations that need to reach beyond an English speaking audience. PhraseSwapper has been invaluable in our practice to move these solutions beyond language and geography constraints.

Microsoft, Excel, and Windows are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.