Joining Text Together and Indirect References
In Section 12 we will use separate calendars for each work centre, but first we need to understand a couple of techniques:
Joining text together or concatenation
The "+" sign is used to add numbers together, but the "&" sign is used to join text together or join text with numbers, e.g.
John Smith JohnSmith =B9&C9
this may look better with a space in between:
John Smith John Smith =B13&" "&C13
it also works with numbers:
Section 11 Section 11 =B17&" "&C17
Indirect references
999
we can add text together to make something that looks like a cell reference:
B 22 B22 =B26&C26
to make it behave like a cell reference, add the =INDIRECT function
B 22 999 =INDIRECT(B30&C30)
a direct reference to a cell on another worksheet:
A Simple Gantt Chart ='Section 4'!A1
an indirect reference to the same cell:
Section 4 A Simple Gantt Chart =INDIRECT("'"&B38&"'!A1")
Thanks for reading Section 11 - Joining Text Together and Indirect References. Please share...!
0 Komentar untuk "Section 11 - Joining Text Together and Indirect References"