When we use some excel formula such as formula to combine the data entered of each cell to together. The regular formula that we usually use are: “CONCATENATE” and “&”.
However, somebody who use the mentioned formula above may frustrate that the data entered of each active cell are connecting together completely. There are no space between each group of the data entered.
This is the example of the using 'CONCATENATE (A1, A2, A3)' formula:
Suppose the data in each of the three active cells as below:
A1 [Sales Accumulation]
A2 [Sales Forecast]
A3 [Actual Sales]
Then we put the active cell names into the formula: = CONCATENATE (A1, A2, A3)
# Result: Sales AccumulationSales ForecastActual Sales
See that the three group of word are connected without any room space.
Here we go to the trick for making space accordingly.
Just add more formula symbols "Double Quotation Mark"[ " " ] between the cell name in a formula, press an [Enter] button one time inside the "Double Quotation Mark"[ " " ] too.
Example 1: [ Formula = CONCATENATE(A1," ", B1," ", C1) ]
Data in each cell: A1= [John], B1= [Tony], C1= [Dave]
Fill out the data into formula like this: = CONCATENATE (A1," ", B1," ", C1)
Obtain: John Tony Dave
Good! now there is a space between each word in the sentence that you can see it in green color I have highlighted.
Example 2: [ Formula = (A1&" "&B1&" "&C1) ]
Obtain: John Tony Dave
The result of the both examples will be the same. Thus, you can select one of the both formula to make your Excel spreadsheet workload up.
Hope the article helps you from Excel problem trucking.
See more tricks:
However, somebody who use the mentioned formula above may frustrate that the data entered of each active cell are connecting together completely. There are no space between each group of the data entered.
This is the example of the using 'CONCATENATE (A1, A2, A3)' formula:
Suppose the data in each of the three active cells as below:
A2 [Sales Forecast]
A3 [Actual Sales]
Then we put the active cell names into the formula: = CONCATENATE (A1, A2, A3)
# Result: Sales AccumulationSales ForecastActual Sales
See that the three group of word are connected without any room space.
Here we go to the trick for making space accordingly.
Just add more formula symbols "Double Quotation Mark"[ " " ] between the cell name in a formula, press an [Enter] button one time inside the "Double Quotation Mark"[ " " ] too.
Example 1: [ Formula = CONCATENATE(A1," ", B1," ", C1) ]
Data in each cell: A1= [John], B1= [Tony], C1= [Dave]
Fill out the data into formula like this: = CONCATENATE (A1," ", B1," ", C1)
Obtain: John Tony Dave
Good! now there is a space between each word in the sentence that you can see it in green color I have highlighted.
Example 2: [ Formula = (A1&" "&B1&" "&C1) ]
Obtain: John Tony Dave
The result of the both examples will be the same. Thus, you can select one of the both formula to make your Excel spreadsheet workload up.
Hope the article helps you from Excel problem trucking.
See more tricks:
- Turn Off / Turn On Scroll Lock Excel Tip To Lock & Unlock On Keyboard
- Excel Solving "This Workbook Contains Links To Other Data Sources"
- 2010 Version Excel Keyboard Shortcuts Begin With [ALT] + [Other Keys]
- Excel Shortcut Key Begin With [Ctrl] And Follow With Another Keys List
- Ctrl + Shift + * (Asterisk) Excel Keyboard Shortcut Select Active Cells
Comments
Post a Comment