Did you know you can combine text from different cells into one cell?
The “&” symbol consolidates text information in the same way as the “+” symbol adds numbers. The space between quotation marks adds a blank character between the separated texts. If you don’t need blank spaces, then take out the blank spaces in your formula.
It is easier for me to show you this tip in the following example:
1. In cell A1, type the text Your
2. In cell A2, type the text Computer
3. In cell A3, type the text Lady
4. In cell A5, type the formula: =A1&" "&A2&" "&A3
Voila! You now get the text Your Computer Lady in one cell A5.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment