Can I create A half row height gap between sentences in one cell?

[tonywatsonhelp]

Hi Everyone,

Ok so in cell A1 I have a sentance like this
="This Page Is For Employees Only" & Char(10) & Char(10) & "Please see HR if You Are Not Staff!"
What I get is this:
This Page Is For Employees Only

Please see HR if You Are Not Staff!

Now the problem I have is my row hright is 15, and 15 is Too big a gap between the two lines, Ideally i'd like it to be just 5 or 7.5 but less, so theres a gap but not a huge gap,
Can this be done? (with a formula) if so please help
Thanks
Tony

 

[rollis13]

First of all, so why use a double & Char(10) ?

 

[tonywatsonhelp]

I Don't Understand?
I use Double Char(10) to drop me down two lines in the cell?
I want First Line, Gap, Second line,
but currently the Gap is the same size as a row, it would look nicer if the gap was less, like half the size. this is what I'm trying to do, I need to do it within a formula like ive shown for reasons that are two complex to try explain at this point.
So, Can you help? I'm really stuck.
Thanks
Tony

 

[Michael M]

I don't believe you can do that within a formula.
In fact, I am not sue VBA will do it either, apart from adjusting the row height !

 

[Rick Rothstein]

If you do not have any other two-line text on Row 1, then try this. Don't use a formula, type the text in but only use one ALT+ENTER between the two lines. Then, with the cell still selected, bring up the Cell Format dialog box, select the Alignment tab and set the Vertical text alignment dropdown to Justify. Now go back to the worksheet and click on the line between the 1 and 2 in the left margin and drag it up/down until you get a spacing you like and then release the mouse button.

 

[tonywatsonhelp]

Thanks Rick and Michael,
Your suggestions have given me the answer if somewhat indirectly,
Instead of having Two rows each 15 high (Merged), I added another 4 rows (merged all 6), made each Row 5 high (Still giving me the total 30 that I was trying to keep), this means that Excel makes the Gap just 5 high as thats the row height now .
I'd never have thought of that without you suggestions so thank you so much.
Tony