How do I take information from one column's cells in Excel and place
it in another column's cells automatically. The second cell would have
information in it and the inserted text would be place where I
dictated.

Ex.

Column A

Cell #1 has the term 'Nike Shoes'
Cell #2 has the term 'Converse Shoes'
etc....


Column D

Cell #1  'Nike Shoes are on sale at....'
Cell #2  'Converse Shoes are on sale at...'

The default text in column D is 'xxxxx are on sale at..." and the
words from column A are inserted automatically.

How would I insert the text ANYWHERE in the other column within the text.

Hi jake8008,

The way to do this is to specify the result cell as a number of text
strings stuck together, or concatenated.  Each component string can
either be constant, something that is written in quotes and taken
literally, or variable, copied from another cell.

In your example, in cell D1, you would want to concatenate whatever is
in cell A1 with the constant text " are one sale at...".

To specify this, you can either use the & operator or the CONCATENATE
function.  So D1 could contain either

=A1 & " are on sale at..."

or

=CONCATENATE(A1, " are on sale at...")

(Note the space character before "are".  Excel won't put this in for you.)

You can concatenate constant and variable strings in any order.  For example:

="Sorry, we have sold all of our " & A1 & ".  Please come back tomorrow."

This is how you could insert the variable text anywhere in the fixed
text.  Just break the fixed text into two parts and concatenate the
first part, the variable text, and the second part.

Similarly, you can include variable text from more than one other
cell.  For example:

="Sorry, we have sold all of our " & A1 & ".  Can I interest you in
some nice " & B1 & "?"


Source:

Microsoft Excel 2000 Help


If any of this is unclear or you need any further information, please
ask for a clarification and I will do my best to help.

--efn

---

Request for Answer Clarification by jake8008-ga on 19 Sep 2004 23:13 PDT

Thanks for letting me know all this.

But, how do you actually do it?  The assistant states what you just
stated below, but also doesn't let me know step by step how to do it.

---

Clarification of Answer by efn-ga on 20 Sep 2004 00:41 PDT

Click on a cell to select it, then type in a line starting with an
equals sign, like those I showed in my answer.  After you have typed
in the text, press the Enter key.  This will store the formula in the
spreadsheet behind the scenes, so you can edit it when you select the
cell, but the concatenated text is what will show when you are not
editing the cell.

In Excel, this is called "entering a formula."  The Excel help
facility covers it, and I will throw in a link.

http://www.camden.rutgers.edu/HELP/Documentation/Windows/excel2000/excel_formulas.htm

If this explanation doesn't help, please tell me more about what you
do and don't know.  I don't want to tell you things you already know
or assume you know things you don't.

--efn

---

Request for Answer Clarification by jake8008-ga on 20 Sep 2004 11:11 PDT

Great. I've got it.

I also figured out how to carry each column over using the autofill feature.

Thanks for your time.

---

Clarification of Answer by efn-ga on 20 Sep 2004 20:34 PDT

You're quite welcome.