|  

» Problem: Unnecessary Empty Characters in Cells

To remove empty characters, use the Trim function.

The Trim function is in the Text category in the Insert Function dialog box.

To insert the Trim function:

1. Select a cell and type:
=Trim
2. Press Ctrl+A to open the Function Arguments dialog box.
Screenshot // Problem: Unnecessary Empty Characters in Cells
Problem: Unnecessary Empty Characters in Cells

Rate This Tip
12 34 5
Rating: 3.16     Views: 25540
No comments have been submitted.
Name
Comment Title
Comments