append a text string to the left of all the cells of a column in excel 2002?

append a text string to the left of all the cells of a column in excel 2002? I have two columns with two values.. I want to append some text to the left of all the cells of Column A and concatenate to the right of all the cells of Column B.
Asked by: Guest \| Views: 306

Total answers/comments: 1

Comments display order:

Guest [Entry]

"Assuming ID is in in Column A
and Employee Name is in Column B

Try this:
=""UPDATE EMPLOYEES SET ID = '"" & A1 & ""' WHERE EMPLOYEE = '"" & B1 & ""'""

in column C row one and then copy the contents of the cells down to generate SQL for each update.

Note: there's no comma before the WHERE."