| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format that Omits Characters
I dont see how to make the code run.
"ShaneDevenshire" wrote: 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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Omits Adjacent Cells | Excel Worksheet Functions | |||
| Formula omits adjacent cells error message | Excel Discussion (Misc queries) | |||
| Format cell with 18 characters | Excel Discussion (Misc queries) | |||
| Format cells for special characters | New Users to Excel | |||
| "Sort Data" omits Row 1 | Excel Discussion (Misc queries) | |||
Threaded Mode
