Howdy, tricky one this....

[Audiojoe]

I have a column of names, but they are downloaded and each cell with a name in it has a large number of spaces before the name itself. So for example, the data in a cell would look like this:

" Jimmy"

Can anyone give me some code that will lok down this column (column G) and remove all the spaces before the names?

I'd be really grateful for this

Thanks

 

[imillar]

Trim and then the cell reference, removes all extra spaces

 

[Dave Hawley]

Hi joe

Try this

Sub GoAwaySpaces()

Columns(7).EntireColumn.Insert
    With Range("H1", Range("H65536").End(xlUp))
        .Offset(0, -1).FormulaR1C1 = "=TRIM(RC[1])"
        .Offset(0, -1) = .Offset(0, -1).Value
    End With
Columns(8).EntireColumn.Delete
 
End Sub

 

[Audiojoe]

Cheers

 

[SamS]

You can also try this if ALL names have spaces in front. Hilite the column,from the Data Menu, Text to Columns, select Delimited from the first window and Spaces from the second. Note the column immediately to the right must be vacant.