Remove Extra Space from Text using Trim Formula.
Between two word some time double space found or Before starting word. Remove space using formula very simple.

Steps –

In the following Image Name list shown in column C. Here found extra space in the text. For remove the space click on next cell of name .

Type =TRIM(      then click on text cell close bracket % Press Enter.

=TRIM(C5) 
Automatically removed unwanted space. Copy that formula & paste in the cell bellow.

In the trim formula behind cells formula shows value. But not use for any work. For remove formula & get text only or actual value use function paste special.

Select cell where to paste text & right click on mouse.

Select Paste Special

Click on Value 

Then Press OK

Your Text will be convert in Normal Text

IF Formula | Learn Excel Formula with Simple Example |