Format that Omits Characters
Hi,
Here is a little bit of code which will do what you want. You could modify
it to be more general.
Sub Hide5Spaces()
Dim cell As Range
For Each cell In Selection
cell.Characters(Start:=1, Length:=5).Font.ColorIndex = 2
Next cell
End Sub
Right now it works only for the first five characters and it work if the
background cell fill is none. But you could change all that.
If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire
"Lemmesee" wrote:
I need a format that omits all of the characters before a hyphen (-) and one
after it.
example;
001- ABC displayed as ABC
I can easily do this with a formula but I need to do it in a format.
|