0

actially till now, i'm doing this job in mysql query. but my bad :( i have start doing things in excel :( but i'm poor at it. some one please help me in going these jobs in excel using FORMULAS.

SQL Querys 

   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 coloumn 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

i need these both queries in excel. please help guys!

user2704822
  • 29
  • 2
  • 8

1 Answers1

1

You can use the CONCATENATE function.

=CONCATENATE(B1," ",C1, " ",D1)
Jeroen Ingelbrecht
  • 808
  • 5
  • 11
  • Here's an example of deleting rows based on a condition. You can easily modify it to use an empty column A as the criterion. http://stackoverflow.com/a/16901714/138938 – Jon Crowell Aug 24 '13 at 23:09