View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
adiacc adiacc is offline
external usenet poster
 
Posts: 4
Default change a value on a string of data

Hi my 1st post so I hope I make sense:
I have strings of data like the EG below
000000000000 0000 000 Andrea xxxx 222 3333
000000000000 0000 000 Louise xxxx 222 3333
So what I need to do is change the names to ***** the names can be different
but the field is always the same number of characters and in the same
location in the line
The file is a TXT file.

Any idea?
Thank you
Andrea