View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Concatenate into 1 cell and drop down lines?

I already figured how to do most of this by myself. I was originally putting
"alt+enter" in the wrong place in the formula.

But I still can't figure out how to make "Aukes;" bold.

Another question: Cells D4, I4, J4, K4 may sometimes be empty. When they are
empty - I prefer those lines to not appear.

Example; instead of this. . .:
Aukes; Jeff & Andrea [A4, B4]
6812 321st Lane NE [C4]

Stacy MN, 55079 [E4, F4, G4]
(651) 462-5716 [H4]



Member - Active
5/17/06 [M4]

.. . .I prefer this:
Aukes; Jeff & Andrea [A4, B4]
6812 321st Lane NE [C4]
Stacy MN, 55079 [E4, F4, G4]
(651) 462-5716 [H4]
Member - Active
5/17/06 [M4]

Is this possible?
I know I won't be able to figure this one out by myself.