VBA for Trim

[normpam]

If I have 10x16 in a cell with a space after it and I use a VBA code For each cell.... cell.value = trim(cell.value) it works just fine. BUT.... if I have text in a cell like ABC terminology access, and there is an extra space after the ABC, then if I am in the spreadsheet itself and use the trim formula, it works just fine. But if I use the same exact VBA command, it completely ignores it and does NOT take out the extra space. Is there some type of quirk with the VBA Trim function?

 

[Fluff]

I don't know why it works that way, but the VBA version of trim only removes extra spaces from the beginning & end of a string. It does not remove them from the middle of the string.
You can however use

Application.Trim

instead

 

[normpam]

I don't know why it works that way, but the VBA version of trim only removes extra spaces from the beginning & end of a string. It does not remove them from the middle of the string.
You can however use

Application.Trim

instead

So, it would be For Each Cell In Range(something) cell.value = application.trim.value?

 

[Fluff]

It would need to be

cell.value = application.trim(cell.value)

 

[normpam]

So, it would be For Each Cell In Range(something) cell.value = application.trim.value?

Got it.. thanks! These quirks drive me crazy!

 

[Fluff]

You're welcome & thanks for the feedback.

These quirks drive me crazy!

I know what you mean.