G
Guest
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?
=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?