Hi,

Doing those things is relatively simple by either using a macro or a
worksheet function and I'm sure if you can give a more specific example of
what you want then help will be forthcoming.

Mike

" wrote:

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