I have a flow chart in txt format. I can import the file into excel,
I select a semicolon delimeter as there are none in the file, and I
don't want excel messing up the spacing. I can export the file with
all the correct spacing, but I am not allowed to save formatting
(changing color, making text bold). So I since each of our jobs in
the file starts with MP, I want to replace those letters with ** if
the job has completed. A list of completed jobs will be on a seperate
worksheet. Each job name is not in its own cell, so I'll have to edit
the string. Any info on how to do this would be very helpfull. Also,
if there is a way to directly edit the file, or other suggestions,
that would be great as well.