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
------------------------------------------------------------------------
sweetboo22's Profile: http://www.excelforum.com/member.php...o&userid=37413
View this thread: http://www.excelforum.com/showthread...hreadid=570936

sweetboo22 Wrote:
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
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 :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=570936

Hi oldchippy,
*_so_just_to_verify,_when_I_upload_this_inventory_ to_the_online_database,_it_will_combine_those_2_ce lls_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


--
sweetboo22
------------------------------------------------------------------------
sweetboo22's Profile: http://www.excelforum.com/member.php...o&userid=37413
View this thread: http://www.excelforum.com/showthread...hreadid=570936

You may want to copy those formula cells after and Paste SpecialValuesOKEsc.

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


Gord Dibben MS Excel MVP

On Fri, 11 Aug 2006 17:57:12 -0400, sweetboo22
wrote:


Hi oldchippy,
*_so_just_to_verify,_when_I_upload_this_inventory _to_the_online_database,_it_will_combine_those_2_c ells_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

sweetboo22 Wrote:
Hi oldchippy,
*_so_just_to_verify,_when_I_upload_this_inventory_ to_the_online_database,_it_will_combine_those_2_ce lls_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
Hi sweetboo22,

Just got your message this morning.

Yes, but do as Gord suggests as well

Glad to be of help

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=570936

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


--
sweetboo22
------------------------------------------------------------------------
sweetboo22's Profile: http://www.excelforum.com/member.php...o&userid=37413
View this thread: http://www.excelforum.com/showthread...hreadid=570936