How to Substitute Multiple Characters in Excel

Save

Microsoft's Excel spreadsheet software offers a wealth of analytical and computational tools for business, finance and personal applications. Some functions operate similarly to other programs in the Microsoft Office family. If you find that you need to replace a set of characters in an Excel spreadsheet, you can accomplish this task quickly and easily using the common "Find and Replace" option that also exists in Microsoft Word without the hassle of selecting each cell and making your changes manually. This command allows you to replace every instance of a set of characters in your spreadsheet with an alternative set of characters.

  • Open a new spreadsheet in Microsoft Excel.

  • Input sample text to carry out the "Find and Replace" command. For example, type "Payables for January 2011" in cell A1 and "Receivables for January 2011" in cell B1.

  • Press CTRL+F to open up the "Find and Replace" dialogue box.

  • Select the tab marked "Replace" and enter the text you want to find on the top line marked "Find." In this example, type the word "January." Then enter the text you want to use in its place on the second line marked "Replace." In this example, type the word "February".

  • Select the button marked "Replace All" at the bottom-left corner of the "Find and Replace" dialogue box. Both instances of the word "January" now read "February."

References

Promoted By Zergnet

Comments

Resources

  • "Excel 2010 Bible"; John Walkenbach; 2010

You May Also Like

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!