Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Fri, 12 Jan 2007 17:41:00 -0800, jchen
wrote: Or you can do a dirty way by hand. Copy the range and paste them in a new sheet. And use the replace all function. And Copy and paste it back. If you have formula included in the sheet. Copy the whole sheet to a new one, replace all, and only copy the range and paste it back. Did you try your solution? When I tried it, it did not change the font, but rather displayed a small box. --ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
How replace a character in a string of characters? | Excel Programming | |||
Replace character in string, not document | Excel Programming | |||
Function to return Character Position of Xth character within a string | Excel Programming | |||
How do I replace * as a character in a string in Excel? | Excel Programming |