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?

hi
several ways to do this.
not sure what version on excel you have but in 2003 on the menu bar.....
toolsoptionsedit tabcheck 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


"Adding Text Without Deleting" wrote:

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?

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 copypaste specialvaluesokesc

Delete column A

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


Gord Dibben MS Excel MVP

On Sat, 6 Jun 2009 20:36:01 -0700, Adding Text Without Deleting <Adding Text
Without Deleting @discussions.microsoft.com wrote:

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?

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!!!! :)

"Gord Dibben" wrote:

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 copypaste specialvaluesokesc

Delete column A

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


Gord Dibben MS Excel MVP

On Sat, 6 Jun 2009 20:36:01 -0700, Adding Text Without Deleting <Adding Text
Without Deleting @discussions.microsoft.com wrote:

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?

I just tried doing this. The problem is, that when I delete the previous column, the cell turns into this "#REF!"

With the original column gone the data disappears,

what I am trying to do is this.

I have catalogs from my companies of products I sell.

I want to be able to add lines at the same time.

Here is a pic of what i'm trying to do, except 100's to 1000's of items with different lines of text.

You missed the step: Select column B and copypaste specialvaluesokesc

1. Open your Excel file and locate the cells where you want to add the additional information.
2. Click on the cell where you want to add the additional information.
3. Move your cursor to the end of the existing data in the cell.
4. Press the spacebar on your keyboard to create a space.
5. Type in the additional information you want to add to the cell.
6. Press Enter on your keyboard to move to the next cell.
7. Repeat steps 2-6 for all the cells where you want to add additional information.

By following these steps, you can add additional information to your cells without erasing the previous data that you have already entered. This will allow you to update your product information without having to start from scratch.

1. To add additional information to the cells without erasing the previous data, you can use the concatenate function in Excel. Here are the steps:
2. Select the cell where you want to add the additional information.
3. Type the equal sign (=) to start the formula.
4. Type "concatenate(" to start the concatenate function.
5. Select the cell that contains the previous data.
6. Type a comma (,) to separate the first argument.
7. Type the additional information in quotation marks.
8. Type a closing parenthesis ()) to end the function.
9. Press enter to complete the formula.

For example, if you want to add the word "new" to the end of the data in cell A1, the formula would be:

This will add the word "new" to the end of the data in cell A1 without erasing the previous data. You can then copy and paste this formula to the other cells where you want to add the additional information.