Is it possible within Excel to create a macro to manipulate the
contents of each cell in a column.

The sort of tasks I wish to do include:

(a) Remove spaces. [i.e. "ca ts 5" becomes "cats5"]
(b) Insert character at a certain position [i.e. "12345" becomes
"123-45"]

Thank you