I need a macro to do the following:
Read thru every row looking at a particluar column.
When I find a certain text string in the column, extract another string from
the column and place it in another column.
Delete the string from the original column.
Continue to last row.

Can anyone give me an exapmle of a macro doing something similar?