FlyerTalk Forums - View Single Post - MS Excel Help
Thread: MS Excel Help
View Single Post
Old May 28, 2006 | 3:05 am
  #36  
Efrem
FlyerTalk Evangelist
40 Countries Visited
3M
All eyes on you!
25 Years on Site
 
Join Date: May 1998
Location: Massachusetts, USA; AA 2.996MM & Plat Pro, DL 1MM, GM & Flying Colonel
Posts: 25,036
The connection at NRT was incredibly smooth today and I ended up with some extra time waiting for my flight. Here's one way to justify the text:

1. Enter "H a p p y sesquipedalianthology" into the cell. There is one space between each letter of the text you want to justify, another one after it. The last part can be any string that's too long to fit into one cell width. If "Happy" with a space between each letter is too big, double-click the cell to activate in-cell editing and set the spaces to a smaller point size.

2. Format the cell to justify horizontally, to align at the top vertically, and to wrap.

3. The row will become deep enough to show all the text, including the junk word. Grab it by the row number at the left and squeeze it back up so only the row you want shows.

Let us know if it works for you!
Efrem is offline