Excel help

[Wardy]

Tweet

I've been playing around trying to do this for a bit and can't manage to do it.

I have a file that I look at in Excel and want to have the values of different fields entering into a statement like I have below. Obvisoult the example below doesn't work but where the A2, B2 and C2 are are where I want the values to be displayed.

INSERT INTO file.name (word1, word2,
number1) VALUES ('A2', 'B2', 'B2');

I've tried all the ways such as =a2 etc that you usually do if you just want to display that info into another cell but it dosn't work in the above scenario.

Is there a way of doing this (that's if anyone actually understands the question?!)

Cheers
Wardy

[ianm]

Wardy,

Not 100% sure I understand.

Are you saying that you have the 3 cells and then want to put their contents into a 4th cell that also has the insert statement in it?

If so you will have to put something like

="INSERT INTO file.name (word1, word2, number1) VALUES ('" & A2 & "', '" & B2 & "', '" & C2 & "');"

Into the other cell

[Wardy]

Absolutely spot on matey just what I was after

How great is is that you can post a question just before you have your dinner then come back after and the answer is there waiting!!!

Cheers
Wardy