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

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

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.