Easiest Trick to Add Space Before Text in Excel

The trick is to combine space character with the cell that you want to add space in front of it. To accomplish this simply use this formula:

Type this formula in new cell:

=" "&A1

Note: " " is space, and A1 is the cell you want to add space in front of it.
Change the A1 with the cell you want to add the space.

2. Now just drag to apply the formula across the column.
3. The new value still a formula, so just copy and paste it as value.

Comments

Popular posts from this blog

How to reconnect your ASTRO

How To Stop Celcom Mobile Internet Prepaid

How To Check Astro Bill With SMS