[SOLVED] Concat in EXCEL like MySQL

I need to convert MySQL queries to excel (using FORMULAS).

SQL queries:

update tablename set col2 = concat(COL2, ' ', COL3, ' ', COL4);

DELETE FROM tablename WHERE COL1 = '';

Query 1: Solved.

Second Query helps to delete the complete row, if a cell in A column is EMPTY.

EX in Excel:

A      B      C      D      E
       10     20    ADE     
ASD    AE     A4    A76

It should become as:

  A      B      C      D      E
ASD      AE     A4    A76

Query 2: my second query DELETE FROM tablename WHERE COL1 = ''; will delete the complete row, if COL1 is EMPTY.