Question

%3CLINGO-SUB%20id%3D%22lingo-sub-1978600%22%20slang%3D%22en-US%22%3EQuestion%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1978600%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CFONT%20color%3D%22%23007600%22%3Ei%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3Es%20it%20possible%20to%20store%20a%20letter%20in%20a%20cell%2C%20after%20which%20a%20reference%20to%20another%20cell%20takes%20place%20behind%20the%20letter%3F%3C%2FSPAN%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3EFor%20example%2C%20lock%20%22B-%22%20in%20cell%20A1%2C%20with%20a%20reference%20to%20cell%20C1%20%22Sample%22%20which%20should%20be%20%22B-Sample%22.%20%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1978600%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

is it possible to store a letter in a cell, after which a reference to another cell takes place behind the letter?

For example, lock "B-" in cell A1, with a reference to cell C1 "Sample" which should be "B-Sample".

1 Reply

@Justin_vld 

Not sure I understood. Why

="B-" & C1

doesn't work?