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

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.

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.

While Excel was designed for numbers, it also involves text in cells. So, for example, if you want to transfer your data and limit the characters for each cell, you may want to know how to count ...