Sorry, I've just re-read your posting (more carefully this time!). You
were asking if this could be done in column B. If you want to follow my
suggestions, first copy column A to column B then perform the actions
on column B.

Hope this helps further.

Pete