Macro to convert specific text and format specific text within a string

Thank You! That made the difference.

Thank you to all who contributed to the solution! I learned alot and can't thank you all enough!!

You all ROCK!!!!!!!!