| From(投稿者): | "news.verizon.net" <mehs@hotmail.com> |
|---|---|
| Newsgroups(投稿グループ): | fj.comp.applications.excel,microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming |
| Subject(見出し): | =clean(a1) |
| Date(投稿日時): | Mon, 25 Aug 2003 19:29:25 GMT |
| Message-ID(記事識別符号): | (G) <pst2b.12405$vy5.1096@nwrddc01.gnilink.net> |
| Followuped-by(子記事): | (G) <3F4A88C3.7D4EFC9@msn.com> |
I want to get rid of special characters from A1. But I want it to be replaced with space so there are 2 or 3 words: A1 TESTchar(27)TEST1char(7)TEST2 After clean it should look like this TEST TEST1 TEST2 Thanks.