Home |
Search |
Today's Posts |
#1
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
=clean(a1)
Try this:
strTest = Replace(TESTchar(27)TEST1char(7)TEST2, char(27), " ") strTest = Replace(strTest, char(7), " ") Let me know if that doesn't work. Mark --- Mark Bigelow mjbigelow at hotmail dot com http://hm.imperialoiltx.com *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to fj.comp.applications.excel,microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
=clean(a1)
if it's just char(27) and char(7):
=SUBSTITUTE(SUBSTITUTE(A1,CHAR(27)," "),CHAR(7)," ") And if there's a chance that those characters will be doubled up: =TRIM(SUBSTITUTE(SUBSTITUTE(A1,CHAR(27)," "),CHAR(7)," ")) "news.verizon.net" wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Clean Up | Excel Discussion (Misc queries) | |||
Clean matrix from 0 | Excel Worksheet Functions | |||
Clean Up Data | Excel Discussion (Misc queries) | |||
End of run 'clean up" . . . | Excel Discussion (Misc queries) | |||
Clean lines | Charts and Charting in Excel |