View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default How to type text in combined cell?

Presume you meant something like this?

If A1 contains: A, A2 contains: M,
A3 to return it as:
A
M

If so, first, format A3 to wrap text,
via FormatCellsAlignment tabCheck Wrap Text

Then place in A3: =A1&CHAR(10)&A2

If you meant just how to break for a new line in a cell when entering data
manually, just press Alt+ENTER where you want to break it.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
Does anyone have any suggestions on how to type text in combined cell?
For example, when I join A1 and A2 cells together, and enter a formula
If true, then type the text A at top and M at bottom, which looks like
following
A
M
in combined cell A1 and A1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric