Compressing letters in a cell

  • Thread starter Thread starter JERRY
  • Start date Start date
J

JERRY

I have a seating chart for a group of students. I want to show each first
and last name in a single cell in the following fashion, without changing
the font size or cell length.

Last Name,
First Name

Some names are quite long. Is there a way to compress the letter spacing
(up to a reasonable degree of course) so that the last name stays on top
without separating the last few letters of the first name

Otherwise, here is what is happening

First Nam
e Last Name

Thanks for any help ... I am using office Excel 2007

Jerry
 
Jerry,

One possibility: After typing the first name, press Alt-Enter, then the last name, then
Enter. You can also select and format either part, then format it for a smaller (or
different) font to get it compressed.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Back
Top