Concatenate and make uniform

J

JYowler

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

I have 482 rows of student data, A thru X columns. I am trying t
export each row to one cell so I can print on index cards. Because o
the different lengths of data, (& some blank cells), it cannot be mad
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? An
suggestions??

Thanks!!

[email protected]
 
J

JulieD

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)
 
J

Jay

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??
Click to expand...

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.
 
Top