I use formatted cells. For instance the cell value is: 1 and cell format is: "Day "Standard.
So the cell displays: “Day 1”.
Now I would like to get this formatted value as a string/text to be used in a formula (e.g. concatenation). This question was asked before but the answer isn’t really a solution. I wonder, if there is any way to do this? There is the CELL function, but the only info_type, which is not available is the formatted value.
Thanks for all suggestions!