VBA Remove First 10 Characters From string

[hobbiton73]

Hi, I wonder whether someone may be able to help me please.

I'm trying to put together a snippet of code which trims the first 10 characters from each cell within a given range.

I've done quite a bit of searching the web for this, and in all honesty, it's left me a little confused, and I'm not sure whether I should use "Trim", "Right" or "Len".

The start and end of my code is as folllows which correctly assigns the command to the correct:

Please Login or Register  to view this content.

I just wondered whether someone could possible look at this please and offer some guidance on how I can resolve this.

Many thanks and kind regards

[hulpeloos]

Please Login or Register  to view this content.

[hobbiton73]

Hi @hulpeloss, thank you very much for taking the time to reply to my post and for putting the guidance together.

Forgive me for asking, but I'm a little sure how I could incorporate this into the script as per lines which I included in my initial post. Is this something you could perhaps help me with please?

Many thanks and kind regards

[jindon]

try

Please Login or Register  to view this content.

[hobbiton73]

Hi @jindon, thank you very much for taking the time to reply to my post and for the solution, it works great.

All the best and kind regards