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

Excel Code TRIM
These Adverts help to pay for this site. ai2

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

These Adverts help to pay for this site ai6.

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

Agoda HolidaysAgoda HolidaysThese Adverts help to pay for this site. ai5

26.1 - 588,296

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