Removing last three Characters

[butler2097]

Hi,

as part of a wider macro, I need to remove/trim in column B the last three characters in each cell so that I am only left with the first 12 characters. any ideas on a quick clean looking bit of code to accomplish this.

Thanks,

Craig

[FDibbins]

I know you said VBA (my weak side), but this would do the same in a formula, maybe you can adapt it?
=left(a1,len(a1)-3)

[stnkynts]

Since you said you wanted 12 characters I focused on that.

Please Login or Register  to view this content.

[butler2097]

Stnkynts,

Thanks a lot, that's worked perfectly.

Regards,

Craig