Remove Space from first character of text

**jaymkent** · 12-19-2012, 07:05 AM

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 ?

**TheNewUnion** · 12-19-2012, 07:08 AM

=TRIM(A2) would do it if you don't mind having an additional column

**:) Sixthsense :)** · 12-19-2012, 07:11 AM

Not sure may be this...

In A1 cell
3/4" BSP 3 MICRON 60LPM

Formula:

Please Login or Register  to view this content.

Drag it down...

**martindwilson** · 12-19-2012, 07:19 AM

select column
then text to columns fixed width
click next
double click on any break lines to remove them
click finish
(you do say space as first character its not clear from your example what space you mean)
if however you want to change
3/4" BSP 3 MICRON 60LPM
to
3/4"BSP 3 MICRON 60LPM
find "x where x = a single space
replace with "