March 15, 2002, Newsletter Issue #14: Joining Text Together #1
Tip of the Week
You can attach text in multiple columns by using the & operator. For Example, assume that you typed the following data in columns A to C:
In column A: First name
In column B: Middle name
In column C: Last name
To place the full name (first, middle, and last names) in column D, type the next formula:
= A1 & " " & B1 & " " & C1
Note a space (" ") between the cells is used to insert a space between the displayed texts.
About LifeTips
Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.
| Guru Spotlight |
 |
