Excel Tips, Tricks, and Shortcuts

Do you know the method of a congregation the data entered from cells? Well, I have two methods for gathering the data entered from each active cell to set into the only one place. To use these formulas to pick up data as you want and link them together in a chain or series into just a single active cell in a worksheet. Here we go to the two ways respectively. 1. Formula ‘CONCATENATE’ = CONCATENATE (text1, text2, text3,) Example: Supposing there are the data entered in each cell as: A1 [Sales Accumulation] A2 [Sales Forecast] A3 [Actual Sales] Replace the active cell names into the formula: = CONCATENATE (A1, A2, A3) Result: Sales AccumulationSales ForecastActual Sales [Click! Kindle Fire HD Tablet - Power by Amazon.com] 2. Formula ‘&’ = text1 & text2 & text3 &, Example: Let’s say the data entered in the active cells follow are as: B1 [Total students] B2 [Students present] B3 [Actual absence] To input the cell names to the series ...