I want to show a cell value in a cell where it is being referenced to a cell that includes a simple formula. e.g.
D4 I want to reference
=C4) and show it as a value, where
C4 has a concatenate formula:
I currently have a reference in D4 cell that is C4, which returns a value, in D4, of 0001-190716-AM-ABERD, for example. When I double click into D4 in order to copy the text as text, I simply get the formula i.e. =C4. What I'm trying to figure out is if there is a way that I can put a formula into D4 that not only returns the value 0001-190716-AM-ABERD, but returns it as text - so when I double click into the cell the text shows and not the formula?