Posted to microsoft.public.excel.programming

Gord Dibben Gord Dibben is offline

external usenet poster

Posts: 22,906

How can I delete unprintable characters using VBA in Excel?

See David McRitchie's TrimAll code.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Gord Dibben Excel MVP

On Wed, 28 Sep 2005 10:18:17 -0500, peterv
wrote:

I want to delete unprintable characters in an Excel sheet using VBA.
I've tried using the CLEAN function, but can't find the correct syntax
to get it to work in VBA. Can anyone help?
Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
delete characters at the end	Stan	Excel Discussion (Misc queries)	5	July 9th 09 08:26 PM
Can you make an Excel Worksheet unprintable	ibvalentine	Excel Discussion (Misc queries)	2	March 9th 07 01:31 AM
Delete first few cell characters	mohd21uk via OfficeKB.com	Excel Discussion (Misc queries)	4	June 7th 06 12:32 PM
Delete characters	Alex	Excel Programming	1	August 9th 04 02:37 PM
Delete characters in cell	AuthorizedUserPF[_2_]	Excel Programming	3	July 14th 03 04:41 AM

All times are GMT +1. The time now is 01:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us