Compressing letters in a cell

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
 
E

Earl Kiosterud

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top