Macro to remove special caracter and all numbers behind,

[abjac]

HI I would like to have some help to remove special caractar and all numbers behind.

The numbers can look like this, format is general. And i would like to remove the space and - and space and the numbers on the left. In sheet 2 column c2 and down(can be empty between)

The numbers can be with different amount of digits

So first number below shall be like this 4073789

There is also a little test sheet to test on.

Need macro for this, because its part bigger project with more macroes.

Please have a look.

Thanks

Abjac

4073789 - 0000010
4075018 - 0006466
4075362 - 0006595
4077148 - 0006721
1733847 - 0000007
0126055097 - 0000552
4079534 - 0006935
4079695 - 0007009
4101319 - 0007092
1734804 - 0000027
4101367 - 0007140
4103108 - 0007261
2011918 - 0000001
1735291 - 0000028
1735299 - 0000008
4102907 - 0007226
1248191 - 0000448
4103334 - 0000214
4104515 - 0000244
4105064 - 0007488
1248525 - 0000895

[HaHoBe]

Hi, abjac,

traditional way - looping thorugh the range:

Please Login or Register  to view this content.

Ciao,
Holger

[abjac]

That did the trick

Thanks Holger.

Have a nice evening Abjac