| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VBA Replace function for single quote
Hi, I want to replace single quote in my excel worksheet using replace function. The way I am using at the moment to replace blank spaces to empty spaces in one entire column is newSheet.Columns("A").Replace " ", "", xlPart I would like to do the same with text containing single quote e.g """PNL """"W"""" TRANSFE to PNLWTRANSFE What do you put in for the substring to search for? thanks in advance Galantis -- galantis ------------------------------------------------------------------------ galantis's Profile: http://www.excelforum.com/member.php...o&userid=24739 View this thread: http://www.excelforum.com/showthread...hreadid=383053 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can the SUBSTITUTE function replace a double quote? | Excel Worksheet Functions | |||
| vlookup and using single quote | Excel Worksheet Functions | |||
| using a single quote ' in SEARCH function | Excel Worksheet Functions | |||
| Removing leading single quote (') from cells with Search/Replace | Excel Discussion (Misc queries) | |||
| Single quote in a where clause | Excel Programming | |||
Threaded Mode
