Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate into 1 cell and drop down lines?
Here is my formula:
=CONCATENATE (A4,";"," ",B4," ",C4," ",D4," ",E4," ",F4,","," ",G4," ",H4," ",I4," ",J4," ",K4," ",L4," ",M4) Returns: Aukes; Jeff & Andrea 6812 321st Lane NE Apt #310 Stacy MN, 55079 (651) 462-5716 (651) 462-2803 Michael Ashley Member - Active 5/17/06 I want it to appear on separate lines (but in one cell) as showen below: Aukes; Jeff & Andrea [A4, B4] 6812 321st Lane NE [C4] Apt #310 [D4] Stacy MN, 55079 [E4, F4, G4] (651) 462-5716 [H4] (651) 462-2803 [I4] Michael [J4] Ashley [K4] Member - Active [L4] 5/17/06 [M4] I also want "Aukes;" to be bold. That would be [A4]. Is this possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate Results from a Validated Drop Down List | Excel Discussion (Misc queries) | |||
Drop down box in a cell | New Users to Excel | |||
Refreshing drop down cell values... | Excel Worksheet Functions | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Can a cell have a drop down list and can also be auto populated | Excel Worksheet Functions |