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



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>