When to use a check box. Use one or more check boxes when you want to: Enable users to make a true/false or yes/no choice. Display true/false or yes/no information that comes from a database, Web service, or other data source.
You can combine or merge text from two or more cells into one cell. For example, if you have one cell in your worksheet with a personâs first name and one cell with their last name, you can combine the first and last names in a new cell. Click the cell where you want to put the combined text. Type =(. Click the cell that contains the first text you want to combine, such as a personâs first name. Type &â â& (a space enclosed in quotation marks). Click the next cell with the text that you want to combine, such as the personâs last name.
1.) Here is an example of what we want to accomplish. The plan is to combine the area codes column with the phone numbers column into a single column. I also want to insert a dash after the area code. 2.) The first step is to enter a formula that is going to combine the cells. Go to Cell C2 and type: =A2&-&B2. The - means to insert a dash between the data of our two columns. 3.) Now right click on the Fill Handle of cell C2.