19.5k views
4 votes
How to remove spaces at beginning of cell in excel

User Yating
by
7.2k points

1 Answer

4 votes

Final answer:

To remove spaces at the beginning of a cell in Excel, you can use the TRIM function or a combination of the FIND and MID functions for more specific removal.

Step-by-step explanation:

To remove spaces at the beginning of a cell in Excel, you can use the TRIM function.

This function removes all spaces from text except for single spaces between words.

If you specifically want to remove only the leading spaces and not the spaces between words or at the end, you can use a formula that leverages the FIND and MID functions.

Steps to Remove Leading Spaces Using TRIM:

Steps to Remove Only Leading Spaces:

The complete question is:How to remove spaces at beginning of cell in excel

User Rusha
by
7.7k points