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