🔗 Text Welder (&)

Goal: Join multiple pieces of text into one string.
The & operator glues values together exactly as they are.

"Hello"
" "
"World"
&
Ready...

💻 Formula Structure

=value1 & value2
  • Symbol: Ampersand (Shift + 7).
  • Action: Concatenates (joins) two values into a Text string.
-- Join strings
="Hello" & "World"
Result String:
-

⚠️ Common Pitfalls

🚫 Missing Space
A1 & B1 results in "HelloWorld".
To fix, you must manually add a space in quotes: A1 & " " & B1.
🔢 Numbers become Text
Even if you join numbers (e.g., 1 & 2), the result "12" is treated as Text, not a Number. Math formulas might not work on it directly.