Question

Below is given the name and address of some students. Combine and show details in an address format using CONCATENATE function.

Answer 1

Procedure: Step 1 – Open a new blank worksheet in LiberOffice Calc Application → Office → LibreOffice Calc 

Step 2 – Enter the following details in appropriate cells

Step 3 – Enter the following formula in F2 cell

= CONCATENATE (A2, “ ”, B2, “ ”, C2, “ ”, D2, “ ”, E2) 

Step – 4 Copy down the formula up to the row of the last employee. 

Output:

Address

Sanjan Kollannur Kechery 680579.

Shaji Amala Bhavan Ollur 680514 Thrissur.

Nithin MRA/258 Mannuthy 680007 Ernakulam.