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.

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

You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

Click in cell C2, then click in the formula bar and type the following: =TRIM (RIGHT (A2, (LEN (A2)-LEN (B2)+1))) This formula instructs Excel to find all the characters in the address except for ...