Program to replace information .... ?
 

Where can I find info on writing a process for Excel. What I am trying
to do is this. I have a .CVS file that is always in the same format.
In 1 of the colums there are standard phrases that come from the our
database. What I'd like to do is take those phrases and use something
like a 'case' command to compare that statement to a list and then based
on the list, insert the correct action into the same field as the
standard phrase.

It would have to loop through all the rows, and those numbers can vary
quite a bit......

Some of the phrases might be along the lines of "unable to contact IP",
or "No collection from device"

The 'correct action' would be the result of comparing the above phrase
against the list of phrases, like the ones above, and so, if the 'unable
to contact IP' is encountered, the correct action would be to 'verify IP'.

The hard part is that 2-3 phrases ("unable to contact IP"), etc, may
have the same result - "verify IP".

The list has a location, company info, etc, and this phrase being the
last item on the row. On the next row down, the information is exactly
the same.

Can anyone help me on the best way to handle this?

Steve