Pasting values from 2 colums into 1 on a seperate workbook?

B

benjamin.talley

I'm looking for an answer to something that has thrown me for a loop.
Is this even possible? I need to take the values from 2 colums on one
workbook and paste them into 1 colum on a seperate workbook so that it
appears [m: "firstcolumvalue" mc: "secondcolumvalue"]. This is due to
the fact that I need to squeeze some more information into a cell that
is being sent to very picky dos based machines which I can't add fields
to its program.

[] denotes the final cell

any input is welcomed and appreciated
-ben
 
B

Bill Kuunders

Can you convert the two columns into one first by using the concatenate
formula or &

Something like in C28 ="m: "&A28&" mc: "&B28

And then paste accross to the other workbook.

Greetings from NZ
Bill K
 
G

Gord Dibben

No need for copying or pasting.

Do the combining in the column on Sheet2

="m: " & Sheet1!A1 & " mc: " & Sheet1!B1

Drag/copy down the column as far as you need.


Gord Dibben MS Excel MVP
 
Top