how to combine two coloums while the rows are not serial

[harisonford]

how to combine two coloums while the rows are not serial

 

[mikerickson]

An example of before and after would be helpful.

 

[harisonford]

coloum 1 coloum 2 coloum 3 must have
what is in 1+2
c1 c2 c3
row 1 a d ad
row 4 b c bc
row 10 c b cb
row 15 d a da


this must be done with one time for all rows together

 

[mikerickson]

Putting the formula =A1&B1 in cell C1 should do that.

 

[harisonford]

of course not this will not work
because the rows are not in sequence

 

[mikerickson]

Copy the formula to the appropriate rows.

 

[harisonford]

this is what i wanted to avoid
when i have hundreds of rows
this is not practical at all

 

[mikerickson]

You can use AutoFilter or some other method to show only the appropriate rows and then use Fill Down to copy the formula where it needs to go.

Without more information as to which rows you want this applied to, there isn't much for us to go on.

 

[harisonford]

this is exactly what i do

first i filter for a certain word in a coloum
then i get the filtered result that lies in many rows that are note in serial sequnce
then i want to add the information of the two coloums together in one third coloum with one copy paste this can not be done

this is what i want to do it is very importent to my work i have 6000 rows in my excel sheet
this is very very time consuming to do it segement by segment
i have to find a way to do it in one go

 

[mikerickson]

I can't guess which rows you need the formula in. Neither can Excel. If you can describe which rows need that formula, perhaps I could explain how you can give that information to Excel.