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
[TABLE="width: 294"]
<colgroup><col></colgroup><tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD]AR:Central IL (Johns, Andrew)[/TD]
[/TR]
[TR]
[TD]AR:MS South (Luther, Susan)[/TD]
[/TR]
[TR]
[TD]AR:Chicago, IL (Martinez, Ben)[/TD]
[/TR]
[TR]
[TD]AR:Memphis, TN (Glaser, Albert)[/TD]
[/TR]
[TR]
[TD]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
[/TD]
[/TR]
</tbody>[/TABLE]
I want to format parts of cells in a list like this:
Each name is in one cell, one row each
[TABLE="width: 294"]
<colgroup><col></colgroup><tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD]AR:Central IL (Johns, Andrew)[/TD]
[/TR]
[TR]
[TD]AR:MS South (Luther, Susan)[/TD]
[/TR]
[TR]
[TD]AR:Chicago, IL (Martinez, Ben)[/TD]
[/TR]
[TR]
[TD]AR:Memphis, TN (Glaser, Albert)[/TD]
[/TR]
[TR]
[TD]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
[/TD]
[/TR]
</tbody>[/TABLE]