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.
Basically I'm trying to avoid having to type in a whole bunch of sql updates. so for example if i have an excel with
ID Employee Name
I want to generate something like this
UPDATE EMPLOYEES SET ID = '135', WHERE employee_name= 'RASPUTIN' UPDATE EMPLOYEES SET ID = '76', WHERE employee_name= 'BUSH'
So perhaps a solution of appending text to the cells and then merging the rows?
I prefer a built in function as I'm not familiar with VBA thanks!