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

+TRIM(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
DreamHost

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