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

Asked By 130 points N/A Posted on -
qa-featured

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

SHARE
Best Answer by Sharath Reddy
Go To Solution
Best Answer
Best Answer
Answered By 590495 points N/A #85524

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

qa-featured

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
  • Posted on -
  • Question Category:
Answered By 130 points N/A #85525

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

qa-featured

Thanks Mate

About srinivas
Questions
2
Answers
1
Best Answers
0
  • Posted on -
  • Question Category:

MS-Excel: How to alter data in a row to column?

Previous

Retrieving All Computer in the Domain with OS Details

Next

Related Questions