LifeTricks.com 
USER CP
Site Navigation 
UPVOTE
UP
39
DOWN
DOWNVOTE
Excel Spreadsheet - Excel Spreadsheet Trick: Compose Text with &
UPVOTE
39
DOWNVOTE
  • life tricks short link

Excel Spreadsheet Trick: Compose Text with &

Excel Spreadsheet

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.

Trick Source:

Is this trick using work of your own without attribution? Click here to PM the user and let them know!

Author Comments

Avatar of Love
amourdange says:

Complicated formulation is unnecessary, as long as you know how to use &. You can compose any text freely with this symbol.



User Comments