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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

benjamin.talley@gmail.com - 15 Aug 2006 21:44 GMT

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

Reply to this Message

Bill Kuunders - 15 Aug 2006 22:34 GMT

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

> 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
[quoted text clipped - 8 lines]
> any input is welcomed and appreciated
> -ben

Reply to this Message

Gord Dibben - 16 Aug 2006 00:06 GMT

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

>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
[quoted text clipped - 8 lines]
>any input is welcomed and appreciated
>-ben

Reply to this Message