View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BobO''''''''B BobO''''''''B is offline
external usenet poster
 
Posts: 3
Default Separate lines in Excel cell

Thanks, it IS easier, but there are other constraints in adjacent cells that
prevent using this solution.
--
BobO'B


"T. Valko" wrote:

This might be better (I know it's easier!):

A1 = Competitive Men
A2 = Team A
B2 = vs
C2 = Team B

Format B2 to center
Format C2 to right align
Select A1:C1
Goto Format CellsAlignment tabHorizontalCenter across selectionOK

Here's what it'll look like:

http://img48.imageshack.us/img48/8844/alignhw8.jpg

Biff

"BobO''''''''B" wrote in message
...
How can I insert separate lines in a worksheet cell?
I'm using Excel to build a Tournament Roster ('coz it's easier to use than
Word tables) and want to enter data like:
Competitive Men
Team A vs.
Team B

in a singe cell and centre the first line, left justify the 2nd and right
justify the 3rd.
--
BobO'B