Macro to clear Characters

**Howardc1001** · 06-07-2021, 02:31 AM

I have data which I import and have code to clear all characters that are not required, except the characters per link below

It would be appreciated if someone could amend my code to incorporate clearing these characters

Please Login or Register  to view this content.

I have also posted on https://www.mrexcel.com/board/thread...cters.1173094/

**Pepe Le Mokko** · 06-07-2021, 02:43 AM

Please wrap your code with proper tags. Just select the code and click the # button.
Your first ( probably manual) tag has a superfluous /

**Howardc1001** · 06-09-2021, 02:00 AM

I only need these characters per the attached spreadsheet to be cleared. This is the result of a PDF file being converted using Wondershare PDF Converter Pro 4

I have shown the characters below that I need cleared using VBA

I have code to clear the other unwanted characters

�
■
,___�

**sintek** · 06-10-2021, 04:12 AM

Perhaps????

Please Login or Register  to view this content.

**Howardc1001** · 06-10-2021, 05:25 AM

Many Thanks Sintek

Your code works 100%

**sintek** · 06-10-2021, 09:46 AM

Glad I could help...Tx for rep +

Macro to clear Characters

LinkBack

Thread Tools

Rate This Thread

Display

Macro to clear Characters

Re: Macro to clear Characters

Re: Macro to clear Characters

Re: Macro to clear Characters

Re: Macro to clear Characters

Re: Macro to clear Characters

Thread Information

Users Browsing this Thread

Similar Threads

Macro to Clear Unregconisable Characters when Data is converted from PDF

Help require to clear unwanted characters from the end

[SOLVED] Macro to delete characters between 2 characters.

macro help with clear null characters in cells

a macro to clear a range of data based on cell result - i.e. if A1 = A2, clear C1: C10

Macro to replace European characters with non "special" English characters?

Clear contents if 2 characters or less

Bookmarks

Bookmarks

Posting Permissions