Macro to remove leading Spaces

[Howardc1001]

I have the following macro to remove leading spaces, but for some unknown reason this is not working on this sample data

I would like the leading spaces removed so values can be formatted with comma sperators


it would be appreciated if someone could assist me

Please Login or Register  to view this content.

See sample Data attached

[Andy Pope]

Add line to loop to remove LineFeed character

Please Login or Register  to view this content.

If you look at the cell you will see that it is not spaces but a new line

[Rick Rothstein]

Your "leading space" is not a space character... it is a Line Feed character. Change this line of code...

dataSet(rw, col) = Trim(dataSet(rw, col))

to this...

dataSet(rw, col) = Trim(Replace(dataSet(rw, col), vbLf, ""))

NOTE: I kept the Trim function call just in case you have some text which really has a leading space in it.

[jindon]

You have hidden character

Please Login or Register  to view this content.

[Howardc1001]

Many Thanks Andy & Ricky for your help and input

Code works perfectly

[Rick Rothstein]

Many Thanks Andy & Ricky for your help and input

What about the code jindon posted? It should do what you want (and possibly a little more) all without using a loop.