Can I read Text Concatenation and Indirect References on EtoBox?
Text Concatenation and Indirect References by sahilsahni20 is a document available to read on EtoBox.
What is Text Concatenation and Indirect References about?
This document discusses two techniques for joining text and numbers: concatenation using the "&" sign to join text and numbers together, and indirect references using the INDIRECT function to treat concatenated text as a cell reference. Concatenation is used to join names, section numbers, and cell references into readable text. Indirect references allow values to be retrieved by treating concatenated text as a cell reference through the INDIRECT function.
- Author
- sahilsahni20
- Language
- EN