So I highlight a given column. I need a macro which first generates a
new column to the right of the single one highlighted. Then I need it
to scan all of the entries in the selected area and whenever it finds
an entry that has an underscore '_' it moves everything right of that
underscore to the new column (same row) just generated. Some entries
have more then one underscore and I only want the macro to move
everything right of the first underscore. When, it goes through the
column again and only checks entries which nothing has been moved. It
moves everything right of the fourth character in those entries which
do not have an underscore or have "NA" in the entry field.

I know this is a tough one, so thank you in advance. I don't even know
if it's possible to do.

~Matt