| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete all special characters in a selection?
Very true - Thanks for the clarification JE.
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 ---------------------------------------------------------------------------- Newsgroups - Where you really can get a free lunch!! ---------------------------------------------------------------------------- "J.E. McGimpsey" wrote in message ... David's excellent macro zaps extra spaces and non-breaking-spaces CHAR(160), but doesn't remove any other characters, nor does it remove single spaces between other characters. Guess it depends on what the OP considers "special". In article , "Ken Wright" wrote: If you are talking about cleaning up data that has been imported from the web, then you might want to take a look at Dave McRitchie's Trimall macro which will zap that garbage but good!! http://www.mvps.org/dmcritchie/excel/join.htm#trimall --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Special Characters | Excel Worksheet Functions | |||
| Special Characters | Excel Discussion (Misc queries) | |||
| special characters (little box) | Excel Discussion (Misc queries) | |||
| Special characters | Excel Worksheet Functions | |||
Threaded Mode
