- Select a destination cell for your formula.
- Type =trim([cell name]), then press Enter.
Note: According to Excel’s Insert Function dialog box, "Trim removes all spaces from a text string except for a single space between words."
Are you an expert at using Excel Tables to Group, filter, and total large lists of data? If so, then you know all the benefits tables can bring to your Excel workbook and how much time they can save you. However, did you know you can name them?