Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text format
I am using a worksheet to track issues and resolutions. For each issue
I may have many responces. What I would like to do is have each responce to start from the left in the same cell. I cannot seem to find the format for this however I have seen this done. For example cell A1 would have the issue and cell A2 would show both lines in one cell. 1 01/01 discussed with Bob working on a new date 01/15 Bob delivered a new template Any ideas on how to format a cell to do this or a function would be great Thanks in Advance Peter |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text format
If you use ALT/Enter at the end of the first part of txt will give you a line
break in the cell. HTH - Sheila www.c-i-m-s.com MS Office training - London " wrote: I am using a worksheet to track issues and resolutions. For each issue I may have many responces. What I would like to do is have each responce to start from the left in the same cell. I cannot seem to find the format for this however I have seen this done. For example cell A1 would have the issue and cell A2 would show both lines in one cell. 1 01/01 discussed with Bob working on a new date 01/15 Bob delivered a new template Any ideas on how to format a cell to do this or a function would be great Thanks in Advance Peter |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text format
Peter
I think you should re-consider what you propose. One of these days you will want to sort by date, issue or response. Having all in same cell will make that difficult. Having said that........................ To have two lines in same cell, type first line the hit ALT + ENTER then type second line and ENTER. Gord Dibben MS Excel MVP On 11 Jul 2006 07:20:25 -0700, wrote: I am using a worksheet to track issues and resolutions. For each issue I may have many responces. What I would like to do is have each responce to start from the left in the same cell. I cannot seem to find the format for this however I have seen this done. For example cell A1 would have the issue and cell A2 would show both lines in one cell. 1 01/01 discussed with Bob working on a new date 01/15 Bob delivered a new template Any ideas on how to format a cell to do this or a function would be great Thanks in Advance Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
zip codes not being saved as text in CSV format | Excel Discussion (Misc queries) | |||
insert text conditionally and format | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Problem with wrap text format | Excel Worksheet Functions |