Posted to fj.comp.applications.excel,microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|
=clean(a1)
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.
|