First, locate the cell that is to show the composed result, use the formulation with & as shown in the screenshot. Click Enter: all texts in A2, B2, C2 and D2 will be composed together to become LizaUSA25@ in F2.
Complicated formulation is unnecessary, as long as you know how to use &. You can compose any text freely with this symbol.
Philonoist. Pursuer of Dreams. Travel Aficionado. Web & Market Researcher. Social Media Analyst. Achiever. Internet Junkie. Independent. Creative
If you found any useful or interesting tricks, tips or hacks today, we ask that you please consider following us on your favorite social media websites. Thank you!
Register For This Site
Are you a robot? Yes or No?
A password will be e-mailed to you.