View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default how do I "keep text together" within a cell to keep it on 1 line?

You can either change your syle and leave the spaces out of the name:
A.B.Person
to keep it all together, or you can control then line break by putting in in
manually (Alt+Enter), or if constructing from a formula, use CHAR(10) as in:

="Now is the time for "&CHAR(10)&"A. B. Person to appear"
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"GT Photo" wrote:

to keep someone's initials from separating between lines with small width
columns - example:

Now is the time for A.
B. Person to appear.

or

Now is the time for
A. B. Person to appear