trouble combining data

J

Jim

Hi, This is what I have
A
1 123
2 567

This is what I want
A
1 1234567
2 567
I want to copy the "5678" from cell B2 and and paste it to the end of data in A1 without having to type the "5678" onto the end of A1 data. I have selected B2, then "copy", selected cell A1 and place cursor at end of cell A1 data, then try to paste but the "paste" function is a lighter color and cannot be selected. How can I combine this data together without re-typing?
I have excel 97.
Please help, Much thanks
Ji
 
E

Earl Kiosterud

Jim,

It sounds as if you want to do this manually.

Put B2 into Edit mode (double-click B2, or select B2 and press F2)
Select the text (drag across it)
Alternatively, you can select B2, and drag across the text in the formula
bar
Copy (Ctrl-C)
Press Esc (not really necessary in this situation)

Put A1 into Edit mode
Paste (Ctrl - V)
Press Enter

You're pasting the text from B2, instead of cell B2 with this method.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Jim said:
Hi, This is what I have:
A B
1 1234
2 5678

This is what I want:
A B
1 12345678
2 5678
I want to copy the "5678" from cell B2 and and paste it to the end of data
Click to expand...
in A1 without having to type the "5678" onto the end of A1 data. I have
selected B2, then "copy", selected cell A1 and place cursor at end of cell
A1 data, then try to paste but the "paste" function is a lighter color and
cannot be selected. How can I combine this data together without re-typing?
 
J

Jim

Hi Earl, Thanks for responding. I tried your suggestion but it only replaced the "1234" data in A1 with "5678" the data in B2. I am trying to end up with cell A1 containing the data "12345678". The challenge is doing it without having to type the "5678" onto the end of "1234", either in the cell or in the formula bar
Thanks for your help
Jim
 
E

Earl Kiosterud

Jim,

It sounds as though you didn't get A1 into edit mode (F2, or double-click
it). With the cursor at the end of 1234, it should have pasted the 5678
that was copied earlier at the cursor.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Jim said:
Hi Earl, Thanks for responding. I tried your suggestion but it only
Click to expand...
replaced the "1234" data in A1 with "5678" the data in B2. I am trying to
end up with cell A1 containing the data "12345678". The challenge is doing
it without having to type the "5678" onto the end of "1234", either in the
cell or in the formula bar.
 
Top