When you copy text from external sources like web pages or database into Excel it may contain leading spaces. Using TRIM function will remove leading, trailing and spaces between words. Sometimes you may want to keep the spaces between words to make your data better readable but want to get rid of leading spaces. You can use a combination of Excel functions to remove only leading spaces. This video explains different ways you can remove leading spaces.

свернуть