View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nicholas Nicholas is offline
external usenet poster
 
Posts: 19
Default How to globally replace a value and set a format.

I have a bunch of records that contain data similar to:
job_history.txt:DC_D01|Update Statistics|01062005|430|01062005|431XXX|2|

I want to change all 2005 to be bold and RED.

Any ideas how to do this?

Thanks