[Concatenate] Or [&] Excel Formula Gathering The Data Entered In The Active Cells

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 of formula as:

= B1&B2&B3

Result: Total studentsStudents presentActual absence

Hope the kits might help you!

See more another Excel shortcuts:

• [F12] Excel Shortcut Key Display The “Save As” Function Fastest Way
• [Ctrl]+[Shift]+[Page Down] Select The Current & Next Sheet In A Workbook
• Turn Off / Turn On Scroll Lock Excel Tip To Lock & Unlock On Keyboard