| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I delete unprintable characters using VBA in Excel?
I want to delete unprintable characters in an Excel sheet using VBA. I've tried using the CLEAN function, but can't find the correct syntax to get it to work in VBA. Can anyone help? Thanks! -- peterv ------------------------------------------------------------------------ peterv's Profile: http://www.excelforum.com/member.php...o&userid=25572 View this thread: http://www.excelforum.com/showthread...hreadid=471435 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I delete unprintable characters using VBA in Excel?
Use WorksheetFunction.Clean(YourString) - for example, if you wanted to clean
the text in cell A3 you would have: Range("A3").Value = WorksheetFunction.Clean(Range("A3").Value) -- - K Dales "peterv" wrote: I want to delete unprintable characters in an Excel sheet using VBA. I've tried using the CLEAN function, but can't find the correct syntax to get it to work in VBA. Can anyone help? Thanks! -- peterv ------------------------------------------------------------------------ peterv's Profile: http://www.excelforum.com/member.php...o&userid=25572 View this thread: http://www.excelforum.com/showthread...hreadid=471435 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I delete unprintable characters using VBA in Excel?
for each cell in Activesheet.UsedRange
cell.Value = Application.Clean(cell.Value) Next Just note that if you are bringing in your data from a web page (for example), there may be characters that CLEAN doesn't clean. -- Regards, Tom Ogilvy "peterv" wrote in message ... I want to delete unprintable characters in an Excel sheet using VBA. I've tried using the CLEAN function, but can't find the correct syntax to get it to work in VBA. Can anyone help? Thanks! -- peterv ------------------------------------------------------------------------ peterv's Profile: http://www.excelforum.com/member.php...o&userid=25572 View this thread: http://www.excelforum.com/showthread...hreadid=471435 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I delete unprintable characters using VBA in Excel?
See David McRitchie's TrimAll code.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall Gord Dibben Excel MVP On Wed, 28 Sep 2005 10:18:17 -0500, peterv wrote: I want to delete unprintable characters in an Excel sheet using VBA. I've tried using the CLEAN function, but can't find the correct syntax to get it to work in VBA. Can anyone help? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete characters at the end | Excel Discussion (Misc queries) | |||
| Can you make an Excel Worksheet unprintable | Excel Discussion (Misc queries) | |||
| Delete first few cell characters | Excel Discussion (Misc queries) | |||
| Delete characters | Excel Programming | |||
| Delete characters in cell | Excel Programming | |||
![peterv[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
