Excel 2002: How to add content to a cell ?
Copy and paste overwrites (as you've discovered). To copy from another cell
and add to existing text elsewhe
Most certain way:
Choose the cell with what you want to copy/add elsewhere. Highlight and
copy the contents in the from the formula bar if it's text (assuming it is).
Hit [Esc].
Go to the cell where you want to add it and then use the display in the
formula bar or to get to the end of the existing entry and paste there.
Another way: Lets say in cell A1 you have:
This Is Text In Cell A1.
and in B99 you have
This is text in cell B99!
and you want A1 to say
This Is Text in Cell A1. This is text in cell B99!
you can change A1 to be a formula like this:
="This Is Text in Cell A1." & " " & B99
alternatively the same thing can be accomplished using
=CONCATENATE("This Is Text in Cell A1.", " ", B99)
"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
|