rrtts
10-25-2006, 03:02 PM
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...
{=concatenate(A1,"/Section 1/",B1,"/Section 2/", C1,"/Section 3/" D1,"/Section 4/",
E1,"/Section 5/", F1,"/Section 6/", G1)}
It would be great if I could bold A1 and word wrap at D1.
Any ideas?
Thanks!
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...
{=concatenate(A1,"/Section 1/",B1,"/Section 2/", C1,"/Section 3/" D1,"/Section 4/",
E1,"/Section 5/", F1,"/Section 6/", G1)}
It would be great if I could bold A1 and word wrap at D1.
Any ideas?
Thanks!