Excel: How to trim space before each cell in a column?
Asked By
130 points
N/A
Posted on - 04/15/2011
![qa-featured](https://www.techyv.com/sites/default/users/superadmin/qa-featured-300x270.png)
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
![](https://techyv.com/sites/default/2016/10/techpedia_logo.png)