Question

The table given below shows the First name, Middle name and Last name of some employees. Show their Full name in the next column using CONCATENATE Function.

Answer 1

Procedure: 

Step 1 – Open a new blank worksheet in Liber Office Calc Application → Office → Libre Office Calc 

Step 2 – Enter the following details in appropriate cells

Step 3 – Enter the following formula in D2 cell = CONCATENATE (A2, “ ”, B2, “ ”, C2) 

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

Output:

FULL NAME

Roby Antony Alappatt

Hema Gangadharan Menon

Cili Jose Vazhappilly

Santhosh Jacob Kannanaikal