Quote:
Originally Posted by Adding Text Without Deleting[_2_]
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.