Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a character and replace with a command in Excel
I need to replace with a formatting command (like you can in Word). I could
set up a macro to do this if it is possible to go to the actual character within the cells, rather than locating the whole cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a character and replace with a command in Excel
It's not like MSWord, but you can get to each character of a string (not a
formula!). For example this bolds colors the 3 character red for the activecell. Option Explicit Sub testme02() Dim myCell As Range Set myCell = ActiveCell With myCell.Characters(Start:=3, Length:=1) .Font.Bold = True .Font.ColorIndex = 3 End With End Sub Jo wrote: I need to replace with a formatting command (like you can in Word). I could set up a macro to do this if it is possible to go to the actual character within the cells, rather than locating the whole cell. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using replace box to change a character into a CR (Alt-Enter char) | Excel Discussion (Misc queries) | |||
How to find and replace in Excel for special characters? | Excel Discussion (Misc queries) | |||
Excel Find and Replace | Excel Discussion (Misc queries) | |||
HELP - How to replace CRLF with a character withing an excel column | Excel Discussion (Misc queries) | |||
How do you find and replace a Wildcard character in Excel? | Excel Discussion (Misc queries) |