I don't think my title describes what I'm trying to do all that well so here is a more detailed description
In Column A, I have a list of people's names in the form of first letter of first name + last name (ex - Bsmith, MJohnson, AWilliams)
I have a number of sumproduct formulas throughout my spreadsheet that look at these names as part of the formulas.
However, some of the people on the list are only part time for the role I am analyzing. I would like to denote a "(Backup)" next to their names without changing the actual names in the cells so I don't have to rewrite all of my Sumproduct formulas.
What I normally do with text is go into Format - Cells and go down to custom and add a "backup" to the end of the cell so it would look like General "backup". But this seems to only work if what's in the cell is a number. When it's text like it is here, the "backup" doesn't show up in the cell.
Is there a way to add text to a cell that actually is just superficial so my formulas still only look at the cell as a name in the form of Bsmith?
Thanks.
In Column A, I have a list of people's names in the form of first letter of first name + last name (ex - Bsmith, MJohnson, AWilliams)
I have a number of sumproduct formulas throughout my spreadsheet that look at these names as part of the formulas.
However, some of the people on the list are only part time for the role I am analyzing. I would like to denote a "(Backup)" next to their names without changing the actual names in the cells so I don't have to rewrite all of my Sumproduct formulas.
What I normally do with text is go into Format - Cells and go down to custom and add a "backup" to the end of the cell so it would look like General "backup". But this seems to only work if what's in the cell is a number. When it's text like it is here, the "backup" doesn't show up in the cell.
Is there a way to add text to a cell that actually is just superficial so my formulas still only look at the cell as a name in the form of Bsmith?
Thanks.