ExcelBanter - remove space

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - remove space (https://www.excelbanter.com/excel-programming/425727-remove-space.html)

capreecorn

remove space

how can i remove space in start of value by using formula ( 222) into (111)

( ) assuming cell.

Jacob Skaria

remove space

Suppose A1 = " 123"

In B1 use the formula '=Trim(A1)' will change that to "123"

If this post helps click Yes
---------------
Jacob Skaria

All times are GMT +1. The time now is 02:14 AM.