Solved: Help with concatenate

[rrtts]

I use the concatenate command to connect 7 cells of data while inserting some text along the way...which potentially results in a long string of text.

Is there anyway to insert a Carriage Return/Line Feed or have it word wrap to get the desired look?

Also, is it possible to have part of the field "bold" based on keywords.

So...

[vba]{=concatenate(A1,"/Section 1/",B1,"/Section 2/", C1,"/Section 3/" D1,"/Section 4/",
E1,"/Section 5/", F1,"/Section 6/", G1)}[/vba]

It would be great if I could bold A1 and word wrap at D1.

Any ideas?

Thanks!

[Bob Phillips]

=CONCATENATE(A1,"/Section 1/",B1,"/Section 2/", C1,"/Section 3/",CHAR(10),D1,"/Section 4/", E1,"/Section 5/", F1,"/Section 6/", G1)

can't do the bold though

[rrtts]

No bold eh...I guess I live without it...thanks for the CHAR(10) though...I'll give it a shot.