Posted to microsoft.public.excel.programming

external usenet poster

Posts: 1

Delete all special characters in a selection?

Does anyone know ofa macro that when run will clear all 'special'
characters out of a cell or selection of cells leaving just numbers or
text characters behind?

Thanks

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Copy Selection - Transpose Selection - Delete Selection	Uninvisible	Excel Discussion (Misc queries)	2	October 23rd 07 04:18 PM
Special Characters	sandyboy	Excel Worksheet Functions	2	September 19th 07 04:02 PM
Special Characters	aftamath	Excel Discussion (Misc queries)	1	October 18th 05 11:02 PM
special characters (little box)	YuChieh	Excel Discussion (Misc queries)	9	June 14th 05 01:41 PM
Special characters	Gilles Desjardins	Excel Worksheet Functions	2	December 8th 04 04:17 AM

All times are GMT +1. The time now is 06:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us