combining columns all the way down

S

sparkroms

I am trying to combine two columns of information in excel but th
concatenate function doesnt seem to work for it. It may just be m
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 an
dog.gif and house.png

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

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?
 
S

sparkroms

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

swatsp0p

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

More info, please and give detailed examples of your data and expecte
results
 
Top