combining columns all the way down

[sparkroms]

I am trying to combine two columns of information in excel but the concatenate function doesnt seem to work for it. It may just be my ineptitude in excel but I just cant seem to figure this out.

I have 3 colums

Column A__________Column B___________Column C
tree_______________ .jpg
dog________________.gif
House______________.png

But I cant seem to be able to make it so that column C has tree.jpg and dog.gif and house.png

Is concatenate the wrong thing to use here? or am I making my formulas incorrectly?

[swatsp0p]

Well, you didn't tell us what formula you are using, so we can only guess that it is incorrect.

Try this in C1:

=A1&B1

and copy this down your range of data.

Does that work for you?

[sparkroms]

okay I got that but now how do I concatenate text that has a quotation mark in it like the following html: <img width="76" height="25" src="blah">

[swatsp0p]

Again, you don't give enough info to us to give a certain answer. Is the text you listed all in one cell? Part in one cell, part in another? If not, are you trying to pull this text from within a cell(s) that contains other text?

More info, please and give detailed examples of your data and expected results.