LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 921
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenate Results from a Validated Drop Down List Debra Dalgleish Excel Discussion (Misc queries) 1 April 27th 06 08:58 PM
Drop down box in a cell upersad New Users to Excel 3 March 26th 06 04:40 PM
Refreshing drop down cell values... Dyce Excel Worksheet Functions 0 August 24th 05 10:49 PM
changing value of a cell by selecting an item from a drop down list Bobby Mir Excel Worksheet Functions 6 June 8th 05 08:33 PM
Can a cell have a drop down list and can also be auto populated Adrian Excel Worksheet Functions 1 March 17th 05 05:05 AM


All times are GMT +1. The time now is 01:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"