Forum Discussion
EXCEL 365 & USING TEXT
Can you please advise, when using the TEXT function formula, on a number, an Ampersand generates allowing V-Lookup function on other Ampersand text cells. However, when using the TEXT sel...
Ampersand is used when you'd like to manually insert the text into the cell independently of such cell format (General, Number, etc), other words you explicitly indicate such value shall be considered as text.
When you return text into such cell by formula ampersand is not generated, that's implicit indication of text in such case.