Hi

I've lurked for a while and not posted before but have got lots of useful help from you all - so a heartfelt thank you for that.

Can anyone help me please?

I'm trying to do a lookup between 2 tabs in my workbook. Column A in tab 1 looking at Column A in tab 2 so pretty simple except that they have spaces before and after the data in each cell - it's all dumped from other systems into excel - and short of spending hours going through each sheet manually and deleting out the spaces which are different on each tab, I am at a loss.

I have tried to learn VBA but even the Idiots Guides don't start low enough for me!

Can anyone help with a macro that will wipe out the spaces either end of the cells in my Column A's please?

You will have my eternal thanks.