Relatively infrequent VBA programmer needs help writing small ap (this
will set me in the right direction with so many others).

I would like to pick any cell in a worksheet, and have it run this Macro
for that column (so that everything is relative to the column selected
and that the row selected is ignored).

As an example using the TRIM function, I want to replace the column
selected with the all the values trimmed.

Step 1:

Determine the column selected (and store it somewhere?)

Step 2:

Insert two columns after the selected one. Put the TRIM value of each
entry in the original column in the the first new column, copy
paste-values into the second new column (so the original can be erased).

Step 3: Erase the original column and the first new column, leaving only
the new trimmmed column. (If you want to save the initial row
value you could return the pointer to the original cell (optional)).

Thanks!