| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace font of one character in a string
I need to replace the font of one character in a text string in a range of
cells. I can do this character by character by hand but I want to automate it. If I use the replace function for one character than the font change is applied to all characters in the cell while the font style (e.g. bold to italic) is limited to the one specified character. Does anyone know how to change the the font for only one character in such a way that I can automate it. (e.g. All arial "1" need to be replaced by windings "1 with a circle around it") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
