The reason that you cannot paste into the cell is because when you press F2
or try to enter another cell, Excel "forgets" what you selected to copy and
focuses on the cell you are entering data into.

Solution: You could join the cells into another cell.

Lets say you have the words "Product Code:" in B2 and your actual code in
C2. In cell D2 type =B2&C2 That will join up the text from both of those
fields.

If you wanted to add a space or a comma like in a name you could type =B2&",
"&C2. That would place the information from B2 to the cell and then place a
comma and then a space to that cell before it added the information from C2.

It is also dynamic in that it will change if you edit information in any
cell that is included in the formula.

If you need to copy and paste it, however, you can copy the information from
the column with the formulas and then select paste special and select values
to paste the information and not the formulas.
--
Hope it helps!
Rip


"Mr. Low" wrote:

Dear Sir,

I need to add content to a cell that already has some data on it by
copying and pasting from another cell .

For example at cell B2, I have €œ Product Code: €œ

When I tried to copy XP-264587P4478Q from another cell and past it to B2
after typing F2 but it does not work. I tried F2 and CTRL V it does not
work either.

May I know the keyboard short cut to get the answer €œProduct Code :
XP-264587P4478Q€� at cell B ?


Thanks

Low




--
A36B58K641