Remove Spaces from Start of Cell

Hello

As the numbers below is imported I can not use auto sum. Beside from the m at the end (easy fix) I have one to four spaces in front of the number. How can I get rid of the spaces and sum 4000 rows. Number Digits is from 1 to 6.

 

1300m
1300m
60m
700m
16m
16m
21m
21m
16m
16m
21m
21m
16m
16m
21m
21m
16m
16m
21m
21m
42m
38m
46m
44m

By: Egil Mortensen

2 thoughts on “Remove Spaces from Start of Cell

  1. andrew walker Post author

    Hey there

    Try using the TRIM function. This removes unnecessary spaces from cells. =TRIM() Just enter the cell reference within the brackets.

    Thanks

  2. 76Normand

    Hi blogger, i must say you have high quality articles here.

    Your website can go viral. You need initial traffic only.

    How to get it? Search for; Mertiso’s tips go viral

Leave a Reply

Your email address will not be published. Required fields are marked *