Excel: How to trim space before each cell in a column?

Asked By srinivas 130 points N/A Posted on - 04/15/2011

Hi Experts,

How can i remove a single space from the front of each cell in a Column.

I want a formula that i can use to remove one empty space in front of each words or words in the cell.

I have data as below

Hand OK

Techyv

Com

You can see in the above table the start is a space. need to remove it

Thanks in advance

Srene

• Status: Open
• Question Views: 1369
• Answer Count: 2
• Vote Up 13 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Sharath Reddy

Go To Solution

Best Answer

Best Answer

Answered By Sharath Reddy 590495 points N/A #85524

Excel: How to trim space before each cell in a column?

What the below does is remove the first space from each cell.

If your data is in cell A1

 

Then put the following in B1

 

=TRIM(A1)

 

Paste the above in cell B1 down as far as you have data in Column A. Now select column B & copy it & select column A, choose Edit > Paste Special > Values > OK. 

 

Now delete column B.

 

Hope this helps….

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 04/15/2011
• Question Category: MS Excel

Answered By srinivas 130 points N/A #85525

Excel: How to trim space before each cell in a column?

Thanks Mate

About srinivas

Questions
2

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/15/2011
• Question Category: MS Excel