ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Text in same cell (https://www.excelbanter.com/excel-discussion-misc-queries/153614-text-same-cell.html)

Rubystarx

Text in same cell
 
Help! I know this can be done but I do not remember how. I need to place text
in the same cell and have it line up underneath each other. I am not talking
about text wrap. If I were using word I would hit "enter", but this does not
work for excel. Currently to accomplish the look I need I am typing the text
and adding several spaces in between to make it line up properly. Can someone
help?

Examples:
How it looks right now:
4 researched 2 purchased
How I need it to look:
4 researched
2 purchased


CLR

Text in same cell
 
Use Alt-Enter as an in-cell carraige return..........

Vaya con Dios,
Chuck, CABGx3



"Rubystarx" wrote:

Help! I know this can be done but I do not remember how. I need to place text
in the same cell and have it line up underneath each other. I am not talking
about text wrap. If I were using word I would hit "enter", but this does not
work for excel. Currently to accomplish the look I need I am typing the text
and adding several spaces in between to make it line up properly. Can someone
help?

Examples:
How it looks right now:
4 researched 2 purchased
How I need it to look:
4 researched
2 purchased



All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com