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...
cindyldeleonoptum Not sure what you mean. The ampersand doesn't just appear. You have to type it into a formula and it causes numbers and/or texts to be joined as one. The end result becomes a text.
For instance, ="10"&"00" will display 1000. But it will be a text. Say this text is in A1. If you then use the TEXT function like:
=TEXT(A1,"$ #,###.00")you can make it look like $ 1,000.00, but it will still be a text.
Please clarify what you have in mind and how you want to relate this to using VLOOKUP.