ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Edit/Replace? (https://www.excelbanter.com/excel-programming/378697-edit-replace.html)

Steph

Edit/Replace?
 
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!!



RichardSchollar

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!!




All times are GMT +1. The time now is 02:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com