Posted to fj.comp.applications.excel,microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming

news.verizon.net news.verizon.net is offline

external usenet poster

Posts: 1

=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.

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
Data Clean Up	Dolphy	Excel Discussion (Misc queries)	1	September 28th 07 10:47 AM
Clean matrix from 0	Arne Hegefors	Excel Worksheet Functions	2	February 15th 07 06:14 PM
Clean Up Data	ultra_xcyter	Excel Discussion (Misc queries)	2	August 11th 06 08:49 PM
End of run 'clean up" . . .	Wayne Knazek	Excel Discussion (Misc queries)	2	July 1st 06 03:55 PM
Clean lines	Gfhcouriers	Charts and Charting in Excel	1	December 10th 04 11:09 AM

All times are GMT +1. The time now is 05:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us