Hello all!! New to the forum...Great place!!

I have 482 rows of student data, A thru X columns. I am trying to
export each row to one cell so I can print on index cards. Because of
the different lengths of data, (& some blank cells), it cannot be made
uniform. Spacing & margins won't work.

My formula so far is: (Taught myself in 2 days!!)

=CONCATENATE(J3&"-"&H3&","&I3&" "&K3&" Enrolled "&TEXT(E3,"m/d/yy")&"
Course-"&D3&" ID# "&C3&" Date sent for ID-"&TEXT(M3,"m/d/yy")
" SSN# "&B3&" "&G3&" DOB-"&(TEXT(F3,"m/d/yy")&" "&X3&"
"&S3&","&T3&","&U3&","&V3&""))

Is there a way to "tab"? or make each cell maximum spaces? Any
suggestions??

Thanks!!




--
JYowler


------------------------------------------------------------------------
JYowler's Profile: http://www.excelforum.com/member.php...o&userid=15983
View this thread: http://www.excelforum.com/showthread...hreadid=274538