|  

» 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.38     Views: 19644
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments