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

+TRIM(A1)

The following screen shot indicates a few examples

Excel Code TRIM


61.1 - 870,707
Scroll down for Comments
0 0 votes
Article Rating
Subscribe
Notify of

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

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x