Home » Questions » Computers [ Ask a new question ]

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: 89
Total answers/comments: 1
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."