I'm working on a spreadsheet in Excel 2007 and I'm trying to get it in one
cell where you can select multiple items to go in that cell. I don't know
if it is possible but if it is please help me.

Can you provide an example of what you are trying to concatenate together.
You can use the CONCATENATE function to combine cell values or the & symbol
to combine cell values and text. For example, the formula:

="Last Updated "&A1&" by "&B1" where A1=Monday and B1=MKan would give you
"Last Updated Monday by MKan"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

I'm working on a spreadsheet in Excel 2007 and I'm trying to get it in one
cell where you can select multiple items to go in that cell. I don't know
if it is possible but if it is please help me.

I am bringing in a data source which has multiple options to choose from and
I'm needing it to where I can pick which ones I want. I hope this makes
since, this is all new to me and the first time I've tried to do this.

"M Kan" wrote:

Can you provide an example of what you are trying to concatenate together.
You can use the CONCATENATE function to combine cell values or the & symbol
to combine cell values and text. For example, the formula:

="Last Updated "&A1&" by "&B1" where A1=Monday and B1=MKan would give you
"Last Updated Monday by MKan"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

I'm working on a spreadsheet in Excel 2007 and I'm trying to get it in one
cell where you can select multiple items to go in that cell. I don't know
if it is possible but if it is please help me.

I guess I misunderstood initially.

Are you trying to pick from multiple tables or are you trying to pick from
multiple rows/columns, from a single data table?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

I am bringing in a data source which has multiple options to choose from and
I'm needing it to where I can pick which ones I want. I hope this makes
since, this is all new to me and the first time I've tried to do this.

"M Kan" wrote:

Can you provide an example of what you are trying to concatenate together.
You can use the CONCATENATE function to combine cell values or the & symbol
to combine cell values and text. For example, the formula:

="Last Updated "&A1&" by "&B1" where A1=Monday and B1=MKan would give you
"Last Updated Monday by MKan"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

I'm working on a spreadsheet in Excel 2007 and I'm trying to get it in one
cell where you can select multiple items to go in that cell. I don't know
if it is possible but if it is please help me.

Example: I'm in cell C3 and I want to bring the table I brought in from my
date source on sheet 4 which are different coverages we offer. I want to be
able to pick the coverages I need without the whole table going in that cell.
I will be repeating this in column C serveral times. I'm sorry I don't know
how to word things so well, thank you so much for helping me.

"M Kan" wrote:

I guess I misunderstood initially.

Are you trying to pick from multiple tables or are you trying to pick from
multiple rows/columns, from a single data table?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

I am bringing in a data source which has multiple options to choose from and
I'm needing it to where I can pick which ones I want. I hope this makes
since, this is all new to me and the first time I've tried to do this.

"M Kan" wrote:

Can you provide an example of what you are trying to concatenate together.
You can use the CONCATENATE function to combine cell values or the & symbol
to combine cell values and text. For example, the formula:

="Last Updated "&A1&" by "&B1" where A1=Monday and B1=MKan would give you
"Last Updated Monday by MKan"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

I'm working on a spreadsheet in Excel 2007 and I'm trying to get it in one
cell where you can select multiple items to go in that cell. I don't know
if it is possible but if it is please help me.

You can do this using Data Validation dropdown where you select multiple items
from the dropdown but some VBA code is necessary.

See Debra Dalgleish's site for an example workbook.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a
dropdown list; an event macro stores selections in adjacent cell, or in same
cell. DataValMultiSelect.zip 18kb updated 22-Feb-07


Gord Dibben MS Excel MVP

On Thu, 17 Jul 2008 14:05:00 -0700, Carrie
wrote:

Example: I'm in cell C3 and I want to bring the table I brought in from my
date source on sheet 4 which are different coverages we offer. I want to be
able to pick the coverages I need without the whole table going in that cell.
I will be repeating this in column C serveral times. I'm sorry I don't know
how to word things so well, thank you so much for helping me.

"M Kan" wrote:

I guess I misunderstood initially.

Are you trying to pick from multiple tables or are you trying to pick from
multiple rows/columns, from a single data table?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

I am bringing in a data source which has multiple options to choose from and
I'm needing it to where I can pick which ones I want. I hope this makes
since, this is all new to me and the first time I've tried to do this.

"M Kan" wrote:

Can you provide an example of what you are trying to concatenate together.
You can use the CONCATENATE function to combine cell values or the & symbol
to combine cell values and text. For example, the formula:

="Last Updated "&A1&" by "&B1" where A1=Monday and B1=MKan would give you
"Last Updated Monday by MKan"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

I'm working on a spreadsheet in Excel 2007 and I'm trying to get it in one
cell where you can select multiple items to go in that cell. I don't know
if it is possible but if it is please help me.

Are you talking about being able to click on that cell and then a selection
of choices appear from where you can choose which one you want to put into
that cell? If so, you're probably wanting a drop-down box. I don't know how
to do that (I'm new too) but I'm sure comeone else here does. But if that's
what you want it's called a dropdown box (in MS Word at least) and I'm sure
MS Excel has a version available.

"Carrie" wrote:

I'm working on a spreadsheet in Excel 2007 and I'm trying to get it in one
cell where you can select multiple items to go in that cell. I don't know
if it is possible but if it is please help me.

Thank you all for your help, I will let you know which way worked the best
for what I'm doing. Again thank you

"ericm" wrote:

Are you talking about being able to click on that cell and then a selection
of choices appear from where you can choose which one you want to put into
that cell? If so, you're probably wanting a drop-down box. I don't know how
to do that (I'm new too) but I'm sure comeone else here does. But if that's
what you want it's called a dropdown box (in MS Word at least) and I'm sure
MS Excel has a version available.

"Carrie" wrote:

I'm working on a spreadsheet in Excel 2007 and I'm trying to get it in one
cell where you can select multiple items to go in that cell. I don't know
if it is possible but if it is please help me.