Thread: Edit/Replace?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RichardSchollar RichardSchollar is offline
external usenet poster
 
Posts: 196
Default Edit/Replace?

Hi Steph

Can you do an EditReplace with

?[Backspace]

for Find What

and just leave Replace With blank.

Hope this helps

Richard



Steph wrote:

Hi everyone. A keylogger I have spits out a file that is very difficult to
read! My daughter makes a lot of mistakes typing, so there are a lot of
backspaces! Unfortunately, the keylogger records a backspace as
[Backspace]. If I drop the file into excel, Is there a way to write code to
start at the beginning of the
file and essentially do an edit/replace, deleting [Backspace] AND the
character before it? Thanks!!