| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VBA Replace function for single quote
thank you. that's pretty neat.
"Bob Umlas" wrote: The result can vary depending on the font used, but you can do the following: in A1, enter =CHAR(ROW()) and fill this down to A255. Now, you can make the symbols larger, obviously, by increasing the font of the column, to, say, 14 pt. - The first 32 rows or so will mainly just show a little square, but scroll down. Now, you can copy column A out to Columns B & beyond, and format each column as a new font to see different symbols, especially Wingdings, etc. You can use this chart to know how to enter the symbol directly. For example, to enter a ¢ sign, you can see it's on row 162, so you can hold the Alt key, and type 0162 from the numeric keypad (leading 0 important), then let go of the Alt key and the symbol will appear. Bob Umlas Excel MVP "lschuh" wrote in message ... I used to have a chart with all the keyboard alpha, numeric, and symbol characters. I would like to know where to find the numeric value for this. Chr$(34) I can't find the Chr$ anywhere. "Roman" wrote: Hi Galantis, try this: Selection.Replace Chr$(34), "", xlPart |
| 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
