Hi I have about 1000 rows of data, and some have a space as the first character in the cell, as shown below
3/4" BSP 3 MICRON 60LPM
3/4" BSP 10 MICRON 95LPM
3/4"BSP 25 MICRON 125LPM
Is there a formula or macro I can use to remove them all in one go ?