Excel Formula

  • Thread starter Thread starter dearrayne
  • Start date Start date
D

dearrayne

Hello All,

I would like assistance in creating an Excel 2000 formula that would
remove all illegal characters and reformat incorrect entries.
 
It depends on what exactly you mean by illegal characters and
incorrect entries, but perhaps the CLEAN function is what you are
after.

=CLEAN(A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You would be much better off using a macro, so that you
can make the changes in place, see
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
where you can read about what you actually have, what the
CLEAN worksheet function actually does, and about copying
data from HTML sources.

What you are probably thinking of as illegal characters are
probably place holders in a font.

This question has been answered in the Excel newsgroups by
people like yourself (peer-to-peer) who volunteer their time to
answer questions. Most of those providing help are connecting
directly to the Microsoft newsservers and not using HTML based
access to newsgroups, which is much slower than using
Outlook Express or other newsgroup browsers.
 
Back
Top