How to Remove the First Character in a Cell if it is a Space

Excel Code TRIM

The easiest way to remove that annoying space that sometimes appears in the beginning of a cell in an Excel spreadsheet.

Just use the TRIM formula and it will remove any spaces that are not single spaces between words.

If your text is in cell A1, just enter this command in any cell, then copy the result back to A1


The following screen shot indicates a few examples

Excel Code TRIM

58.1 - 819,207
Scroll down for Comments
0 0 votes
Article Rating
Notify of

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Inline Feedbacks
View all comments
Would love your thoughts, please comment.x