Kerry Newman
New Member
- Joined
- Feb 23, 2018
- Messages
- 19
- Office Version
- 365
- 2019
- Platform
- Windows
All,
I want to format parts of cells in a list like this:
Each name is in one cell, one row each
<colgroup><col></colgroup><tbody>
</tbody>
I want to format parts of cells in a list like this:
Each name is in one cell, one row each
AR:Central IL (Johns, Andrew) |
AR:MS South (Luther, Susan) |
AR:Chicago, IL (Martinez, Ben) |
AR:Memphis, TN (Glaser, Albert) |
AR:NE/IA (McGrath, Jason) I want to make the characters between the ( ) turn white, including the ( ). For example, AR:Central IL (Johns, Andrew) would still have the full text in the cell (to be used in other formulas) but the cell only shows AR:Central IL The (Johns, Andrew) part of the text would just be white font, not visible. How can I do this with out formatting each cell individually? The list is several hundreds of lines long. Thanks |
<colgroup><col></colgroup><tbody>
</tbody>