View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Excel 2002: How to add content to a cell ?

Select the cell with the XP-### stuff
Copy the characters you want from the formula bar.

Select the other cell
and paste into the formula bar.

Although, if you have a column of these, as a user, I would find that
redundant. I'd just put the "Product Code" label in a header for that column.

Another suggestion would be to use a custom format (if that text doesn't
change):

Format|Cells|Number tab|Custom category:
"Product code: "@

(But I'd find that just as redundant.

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


--

Dave Peterson