| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a workbook, how do I not have initials split and wrapped?
I have a vacation schedule where the first tab pulls people's initials from
other tabs. It splits & wraps their initials. Changing the width of the column is not the solution since there can be 15 sets of initals in any given cell. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In a workbook, how do I not have initials split and wrapped?
If you want to stop the cell from wrapping, click on Format | Cells |
Alignment tab, and un-check the Wrap Text option. Is this what you mean? I'm a bit confused ... Pete On Oct 9, 8:47 pm, Leeney wrote: I have a vacation schedule where the first tab pulls people's initials from other tabs. It splits & wraps their initials. Changing the width of the column is not the solution since there can be 15 sets of initals in any given cell. Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In a workbook, how do I not have initials split and wrapped?
Sorry, guess I wasn't very clear. I need the cell to wrap since there can be
up to 15 people's initials in any cell. My problem is that on the tally it breaks up the people's initials. ie: MSN,CMA,RIM,SP G, DAK For instance, on MSN's page cells now read =IF(M360,"MSN","") in order to be pulled to the tally page. Is there some command to keep this from happening? Thanks Leeney "Pete_UK" wrote: If you want to stop the cell from wrapping, click on Format | Cells | Alignment tab, and un-check the Wrap Text option. Is this what you mean? I'm a bit confused ... Pete On Oct 9, 8:47 pm, Leeney wrote: I have a vacation schedule where the first tab pulls people's initials from other tabs. It splits & wraps their initials. Changing the width of the column is not the solution since there can be 15 sets of initals in any given cell. Any suggestions? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In a workbook, how do I not have initials split and wrapped?
I see now.
You obviously have some formula to concatenate the initials with commas. You should arrange for this formula to add a comma and a <space after each set of initials, and then the wrapping will take place at the <space without splitting the initials. Hope this helps. Pete On Oct 10, 2:36 pm, Leeney wrote: Sorry, guess I wasn't very clear. I need the cell to wrap since there can be up to 15 people's initials in any cell. My problem is that on the tally it breaks up the people's initials. ie: MSN,CMA,RIM,SP G, DAK For instance, on MSN's page cells now read =IF(M360,"MSN","") in order to be pulled to the tally page. Is there some command to keep this from happening? Thanks Leeney "Pete_UK" wrote: If you want to stop the cell from wrapping, click on Format | Cells | Alignment tab, and un-check the Wrap Text option. Is this what you mean? I'm a bit confused ... Pete On Oct 9, 8:47 pm, Leeney wrote: I have a vacation schedule where the first tab pulls people's initials from other tabs. It splits & wraps their initials. Changing the width of the column is not the solution since there can be 15 sets of initals in any given cell. Any suggestions?- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In a workbook, how do I not have initials split and wrapped?
Hi Pete,
That is definately a good idea - do you mean =IF(M360,"MSN ,","") or =IF(M360,"MSN, ","") I already tried that. It still will seperate anything between the quote marks. Might there be a command (like a $ in a formula will keep the number or letter from incrementing) to keep whatever is between the quotes together? Leeney "Pete_UK" wrote: I see now. You obviously have some formula to concatenate the initials with commas. You should arrange for this formula to add a comma and a <space after each set of initials, and then the wrapping will take place at the <space without splitting the initials. Hope this helps. Pete On Oct 10, 2:36 pm, Leeney wrote: Sorry, guess I wasn't very clear. I need the cell to wrap since there can be up to 15 people's initials in any cell. My problem is that on the tally it breaks up the people's initials. ie: MSN,CMA,RIM,SP G, DAK For instance, on MSN's page cells now read =IF(M360,"MSN","") in order to be pulled to the tally page. Is there some command to keep this from happening? Thanks Leeney "Pete_UK" wrote: If you want to stop the cell from wrapping, click on Format | Cells | Alignment tab, and un-check the Wrap Text option. Is this what you mean? I'm a bit confused ... Pete On Oct 9, 8:47 pm, Leeney wrote: I have a vacation schedule where the first tab pulls people's initials from other tabs. It splits & wraps their initials. Changing the width of the column is not the solution since there can be 15 sets of initals in any given cell. Any suggestions?- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In a workbook, how do I not have initials split and wrapped?
No, I mean on your tally page what is the formula that produces:
MSN,CMA,RIM,SP G, DAK Is it something like: =Sheet1!N36&","&Sheet2!N36&","& ...etc? If so, then you should change the "," to ", ", i.e. put a space after each comma within the quotes. Then you should get something like: MSN, CMA, RIM, SPG, DAK because of the spaces. Hope this helps. Pete On Oct 10, 3:41 pm, Leeney wrote: Hi Pete, That is definately a good idea - do you mean =IF(M360,"MSN ,","") or =IF(M360,"MSN, ","") I already tried that. It still will seperate anything between the quote marks. Might there be a command (like a $ in a formula will keep the number or letter from incrementing) to keep whatever is between the quotes together? Leeney "Pete_UK" wrote: I see now. You obviously have some formula to concatenate the initials with commas. You should arrange for this formula to add a comma and a <space after each set of initials, and then the wrapping will take place at the <space without splitting the initials. Hope this helps. Pete On Oct 10, 2:36 pm, Leeney wrote: Sorry, guess I wasn't very clear. I need the cell to wrap since there can be up to 15 people's initials in any cell. My problem is that on the tally it breaks up the people's initials. ie: MSN,CMA,RIM,SP G, DAK For instance, on MSN's page cells now read =IF(M360,"MSN","") in order to be pulled to the tally page. Is there some command to keep this from happening? Thanks Leeney "Pete_UK" wrote: If you want to stop the cell from wrapping, click on Format | Cells | Alignment tab, and un-check the Wrap Text option. Is this what you mean? I'm a bit confused ... Pete On Oct 9, 8:47 pm, Leeney wrote: I have a vacation schedule where the first tab pulls people's initials from other tabs. It splits & wraps their initials. Changing the width of the column is not the solution since there can be 15 sets of initals in any given cell. Any suggestions?- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separate/Split all the worksheets in a workbook into different fil | Excel Discussion (Misc queries) | |||
| Need Period After Initials | Excel Worksheet Functions | |||
| Create initials from Full name | Excel Discussion (Misc queries) | |||
| Workbook split into two after opening | Excel Discussion (Misc queries) | |||
| How to pluck out initials of a 2 or 3 word name | Excel Worksheet Functions | |||
Hybrid Mode
