Adding text without erasing previous text?

[Adding Text Without Deleting]

I run a store with over 5000 products and I upload them by excel. My 5000
products have data already in there cells. I need to add addition information
without erasing the previous data already entered over the 5000 products in
the cell. How do I do this?

 

[FSt1]

hi
several ways to do this.
not sure what version on excel you have but in 2003 on the menu bar.....
tools>options>edit tab>check as see if the "edit directly in cell" box is
checked.
if it is, you can edit the cell by double clicking the cell to go to edit
mode or pressing the F2 key.
if not, and you may not want to (i don't), you can leave it unchecked, ok out.
do the following instead.
with the mouse click into the formula bar. that is the long blank strip
above the sheet which also display the cell contents. you can edit there.
or
click the F2 key. that will put in into edit mode (in the fomula bar).

regards
FSt1

 

[Gord Dibben]

Do you want to add the same text to each of the 5000 products?

Assuming the products are in column A starting at A1

In B1 enter =A1 & " " & "more text"

Double-click the fill handle to copy down.

Select column B and copy>paste special>values>ok>esc

Delete column A

If different text for each product...................F2 to get into edit
mode then ad the text.


Gord Dibben MS Excel MVP

 

[Adding Text Without Deleting]

I am so happy that there are people like you around to help people without as
much knowledge Gord. I am so excited that you helped me. Thank you so
much!!!!