Replace macro or trim macro cant work

[abjac]

HI I have a little problem. In on specific cell c34 I need to removed spaces but keep the leading zero.
Try put this In cell c34 sp = space

sp059053spsp061spsp063 If I use a replace macro recorded it remove the first zero.
If I use below code it keep the first zero but don't remove the remaining spaces.

Please have a look thanks

Abjac

Example of a code for trim but it only remove the first space and keep the zero.

Please Login or Register  to view this content.

[lancer102rus]

use

Please Login or Register  to view this content.

[sweep]

Does this help?

Please Login or Register  to view this content.

[oeldere]

@abjac

you posted 645 times, so i think you will know the forumrules.

Please post your code between tags ##

[abjac]

Sorry oeldere off course I know that just forgot to do it hehe

[abjac]

HI Lancer I tried with yours don't really know where to put this line in, tried some combinations but all fall. Could you show the hole code please.
Sweep. Your code works brilliant its and replace but I guess the big difference is that it make it as text before. But it works perfect. Thanks allot
Will wait for lancer before I close this. Thanks to both

Sincerely
Abjac

[AB33]

Please Login or Register  to view this content.

Instead of

Please Login or Register  to view this content.

[abjac]

Hi AB33. it did remove the first space in the beginning and did not remove zeroes but it did not remove the remaining spaces.

Thanks

Abjac

[lancer102rus]

Hi, abjac! Try this

Please Login or Register  to view this content.

or use sweep code

[AB33]

Trim does not remove zeros, but ONLY spaces. You need to use substitution or replace methods.

[abjac]

Sorry AB I write wrong it removed the first space but not the other. Thanks

HI lancer your new one is working I added this line also to be sure it remove comme.

Please Login or Register  to view this content.

I guess this is not a trim code but nearly the same as the other from sweep thanks allot to all

I will mark this as solved
have a nice day thanks

Abjac

[lancer102rus]

You code will generate 2 char "'".
Use this

Please Login or Register  to view this content.

[lancer102rus]

oops......