Removing blank spaces before and after in a cell using VBA

[rz6657]

I have a column where users paste a list of numbers (up to 120). It starts at D4 and ends at D123, column D. Sample numbers are: 11111, 11111a, 22222c. Sometimes the users paste numbers and they have spaces either before or after the numbers... Is there a simple code that will solve this for only column D from D4 to D123?

Thanks...

[mehmetcik]

Hi

In D1 type " 1234 " but without the inverted commas. [ space, 1, 2, 3, 4 space.
in e1 type =trim(D1) This will remove any useless spaces.
in f1 type =len(e1) This proves that the spaces have been removed.

[mehmetcik]

If you want to do this using VBA then then.

Please Login or Register  to view this content.