adding information to cells uniformally

  • Thread starter Thread starter sweetboo22
  • Start date Start date
S

sweetboo22

Hi, I have a sheet where I have titles of some inventory and want to add
't-shirt' at the end of each inventory name. Is there a simple way to
do this rather than copy and pasting for each of my inventory names. I
have several thousand and am praying there is an easier way to do this.

thanks
Brenda
 
sweetboo22 said:
Hi, I have a sheet where I have titles of some inventory and want to add
't-shirt' at the end of each inventory name. Is there a simple way to
do this rather than copy and pasting for each of my inventory names. I
have several thousand and am praying there is an easier way to do this.

thanks
Brenda
Click to expand...
Hi sweetboo22,

Say in cell A1 you have "White", then in cell A2 you put this formula

=A1& " t-shirt"

note the space after the first " in t-shirt, so that the result is

White t-shirt

oldchippy :)
 
Hi oldchippy,
*_so_just_to_verify,_when_I_upload_this_inventory_to_the_online_database,_it_will_combine_those_2_cells_automatically_and_treat_it_as_one?__

and thanks so much for the super fast reply, honestly you have NO ide
how much this helps as I was preparing to spend a lot of time pasting
:)
Cheers
Brend
 
You may want to copy those formula cells after and Paste Special>Values>OK>Esc.

Just to be on the safe side when moving to the online database.


Gord Dibben MS Excel MVP
 
sweetboo22 said:
Hi oldchippy,
*_so_just_to_verify,_when_I_upload_this_inventory_to_the_online_database,_it_will_combine_those_2_cells_automatically_and_treat_it_as_one?__*

and thanks so much for the super fast reply, honestly you have NO idea
how much this helps as I was preparing to spend a lot of time pasting.
:)
Cheers
Brenda
Click to expand...
Hi sweetboo22,

Just got your message this morning.

Yes, but do as Gord suggests as well

Glad to be of help

oldchippy :)
 
Thanks OldChippy and Gord, that worked perfectly. I was able to upload
about 10,000 items yesterday with ease. Put another post up over the
weekend about figuring out how to put items (child lines) under parent
lines with some kind of macro. am not sure if it is possible or not.

The thread it titled "would love help creating a macro to insert
information" I think I am going to try and go back and explain it
better.
thanks again.
Brenda
 
Back
Top