I have some data pulled from a SQL database that we put into excel to do some reporting. (We don't have direct access to the SQL data so we can't write any reports there.)

A couple of the columns/fields have information that looks like the following examples:

NY DEC2012-30.0000 USC/LB
LN NOV2012+440.0000 USD/MT
NY DEC2012+29.0000 USC/LB
NY DEC2012+26.5000 USC/LB
NY DEC2012+51.0000 USC/LB
LN NOV2012+440.0000 USD/MT
LN JAN2013+500.0000 USD/MT


(Each of these is in a separate cell with in that particular column)

I need to do the following things with the data in these columns.

1.) If the cell contains USC/LB, then do nothing at all.
2.) if the cell contains USD/MT then do the following:
a.) BOLD the 1st two characters (almost always it will be the letters "LN")
b.) Convert the value after the "+" or "-" (I'll call it AMT here) by doing the following calculation:
i.) AMT divided by 22.046 (Example 400/22.046 (rounded to the 2nd decimal place, but showing 4 total decimal places) which would be 19.9600)
ii.) make the results of the calculation to appear in red text (just the number, nothing else)
c.) Change the USD/MT to USC/LB and make those letters bold.

>> So the above data should look like the following when run:
NY DEC2012-30.0000 USC/LB
LN NOV2012+19.9600 USC/LB
NY DEC2012+29.0000 USC/LB
NY DEC2012+26.5000 USC/LB
NY DEC2012+51.0000 USC/LB
LN NOV2012+19.9600 USC/LB
LN JAN2013-22.6800 USC/LB
The file will vary in length each time we get it (sometimes as many as 3000 lines), and those strings will appear in two columns with the headings:
purch_valn_string
sales_valn_string

I'm hoping to create a macro (that possibly would be called by an other macro later as we develop this) that will do the formatting quickly.

Any suggestions?

Thank you in advance