Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Concatenate and make uniform
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 |
#2
|
|||
|
|||
Hi
welcome :) the question i'm asking myself is why don't you put the different bits that you need lined up in different columns and then print that onto the index cards and then it will be uniform .. e.g. column AA.....=J3&"-"&H3&","&I3&" "&K3 AB....="Enrolled "&TEXT(E3,"m/d/yy") AC....="Course-"&D3 AD....="ID# "&C3 AE.....="Date sent for ID-"&TEXT(M3,"m/d/yy") AF.....="SSN# "&B3&" "&G3 AG.....="DOB-"&(TEXT(F3,"m/d/yy") AH.....=X3&" "&S3&","&T3&","&U3&","&V3 then when you print choose AA3:AH100 (or whatever) as the print range. Will this work? Cheers JulieD PS you can concatenate just by using the structure of =A1&" "&B1 instead of =CONCATENATE(A1,B1) "JYowler" wrote in message ... 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 |
#3
|
|||
|
|||
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. ... ... Any suggestions?? If I had this assignment, I'd use Word's "Mail Merge" feature with the spreadsheet as the data source. Fine-tuning the layout is much easier with Word. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|