Excel Tips, Tricks, and Shortcuts

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 Accumulation Sales Forecast Actual 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 [ E...