How to add character to cell that doesn't print? (need for formula but want to hide on print)

[c.clavin]

Hi guys, I am trying to add a character/code into certain cells for formulas in other columns to use, but not show the character/code when printing, to avoid confusion. Is there any way to do this without causing issues? Thank you!

 

[Skyybot]

Formulas don't print unless you have View Formulas option active.

 

[c.clavin]

Sorry I should have explained it better. I want the cell to print like "Sample Text" but appear in the cell as something like "Sample Text †" or some kind of character for me to use in a formula. I'm using the "†" as an identifier to count a cell as 2.

 

[Tetra201]

Maybe

="Sample Text"&CHAR(13)

 

[c.clavin]

Awesome! Thank you so much this worked great, it even worked across formulas, which was my biggest worry you are great!

 

[Tetra201]

Glad to have helped.