Merge columns data

[nhbmark]

Hello,

I have two columns. B and D
I need to take the information from D and merge it with B.
so example B2 would look like 205EVOBBLP

Just dont know what the formula would be on that .

Any help would be great!!!











Uploaded with ImageShack.us

 

[Dryver14]

As the letters in column B are different to C you need to copy column B somewhere else eg column ZZ or something then it is a simple case of

=ZZ2&D2

otherwise insert a new column for the formula

 

[Lidsavr]

The formula itself is pretty simple: =B2&D2.

You will need to go to the first blank column to the right and place the formula above. Fill down after you are done. You will now have a column with the values you want, but they are all formulas. If you still want the information to be actual values, you need to copy the new column and paste it in the same or another location using "Paste Special" --> Values back into column D.

Lidsavr

 

[nhbmark]

great..thank you guys