Delete any character after the 7th character

Hello,

Can someone help with the following please?

Using a macro, I want to be able to copy Column A into Column B (attached) but delete any character after the 7th - including space.

Thanks in advance

Not really a macro, but you should think about using ASAP utilities. They have a button that you can do exactly what your asking along with hundreds of other things. It has saved me so much time looking for scripts! And its free

Hello,

Thank you singerj6 for your help. Its exactly what I wanted
Thanks nrichardson for your advice, I'll download it and see what its like

Thanks!