View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EazyExcel EazyExcel is offline
external usenet poster
 
Posts: 2
Default identify a word in a string then change the format of that word

Using VBA
For each cell in a row, I want to identify a word in a string then
change the format of that word. For example,
For text in a cell " Id: 00098765 Description: For help with this
account number contact XYX Updates: This number is not useful."

I want the color of Id, Description, Updates changed to red and bold
and moved to a separate line in the same cell.
Id: 00098765
Description: For help with this account number contact XYX
Updates: This number is not useful."

Any help will be appreciated

Thank You