The function should look something like this: "RIGHT (B2,4)." Remove text strings using Excel 2007's "Replace" command. Select all the cells in which you want to replace characters.

Excel represents such characters as boxes. In this post, we will show you how you may identify and clean these characters from your Excel data. How to remove Non-printable Characters in Excel?

This post will show you how to remove the first or last few characters or certain position characters from the text in Microsoft Excel.

When you prepare employee salary reports, revenue charts and other business financials, you may find yourself inputting more than just numerical characters into Excel's many worksheet grid cells ...