Macro for trim forumla/ convert text to numbers

Hi, I’m new to vba/Macros and I wonder if any one could please help with the VBA code for this.
I have two sheets, Sheet1 and Sheet2.
Sheet 1 has an undetermined number of rows and will vary weekly
Sheet 1 has 16 columns
Sheet 2 has an undetermined number of rows and will vary weekly
Sheet 2 has 11 columns
I need a Macro which will do the follow steps.
On sheet 1:
Trim column A (Remove all spaces from a text string for all rows in this column – I would typically use ‘Trim’ formula for this when doing it manually)
Trim column B (Remove all spaces from a text string for all rows in this column – I would typically use ‘Trim’ formula for this when doing it manually)
On sheet 2:
Trim column A (Remove all spaces from a text string for all rows in this column – I would typically use ‘Trim’ formula for this when doing it manually)
Trim column C (Remove all spaces from a text string for all rows in this column – I would typically use ‘Trim’ formula for this when doing it manually)
Column K – Numbers are stored as text. I need to convert to number format and remove leading zeros for all entries in that column.
And that’s it! If anyone could help that would be great! I’m trying to get VBA to assist me with what I’m trying to do and then teach myself by breaking down the individual steps.

See if this works.

Please Login or Register  to view this content.

Amazing! Thankyou so much!!! :D