"The devil is in the details." How true of composing a an Excel spreadsheet. Text used for one part may or may not be used for another. That is why it is better to break down the text into the smallest permissible part and merge that part with other text when needed. This leads to both easier management and a better understanding of an Excel spreadsheet.
- Skill level:
Other People Are Reading
Click on the spreadsheet cell in which you would like to put the merged text.
Click on the "Toolbox" icon in the header above the worksheet. It is located between the "Gallery" icon and the "Zoom" box, third from the end. The "Toolbox" will appear in the upper right hand corner of the screen.
Click on the "Formula Builder" tab in the "Toolbox." It is the third tab labelled "fx" in the header.
Type "concatenate" into the search box that appears under the header of the "Toolbox." Double click on the "concatenate" result underneath the search box. A shaded box will appear at the bottom.
Enter the location of the first text that you want to merge into the box titled "text1." Type "A1" if the text that you would like to enter is in cell A1. You can also first click on the empty box next to "text1" and then click on the cell that you want to enter.
Enter the desired cell into "text2" box. If you would like to merge more than two sources of text, then click on the "+" at the end of the line. If you would like to subtract a source, then click "-". When finished, press the Enter key.
Tips and warnings
- Be careful to not go overboard with inputting a series of text inputs. You may never find where you made your mistake.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for