165k views
3 votes
How to add space in excel between text

User Jbandi
by
7.7k points

1 Answer

5 votes

Final answer:

To add space between text in Excel, use the CONCATENATE function or the ampersand operator with a space. To add a comment to a cell, select the cell, click 'New Comment' on the ribbon, and type in the comment box.

Step-by-step explanation:

Adding space between text in Excel can be achieved by using the CONCATENATE function or the ampersand (&) operator. For instance, suppose you have a first name in cell A1 and a last name in cell B1 and you want to add a space between them in cell C1. You can use the formula =A1 & " " & B1 or =CONCATENATE(A1, " ", B1) in cell C1. This will combine the text with a space in between.

However, if you wish to add a comment to a cell rather than combining text, you would first select the cell and then click New Comment in the tools ribbon. A comment box will appear where you can type your comment. Comments are useful for making notes or providing additional information without changing the actual cell content.

User Saransh Singh
by
7.7k points