Skip to content

Opening book details…

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