| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting for mail merge
When I enter text, then alt-enter, there is a "return" when I mail merge -
but if I do another alt-enter to create a blank space, that one doesn't merge. Example in the excel cell, I type: dsfkdfjkfj ;akdfjdkjf ;kdjf df alt-enter alt-enter asldefj alskdjfk ;akfj dflkj alt-enter I want this to export as: dsfkdfjkfj ;akdfjdkjf ;kdjf df asldefj alskdjfk ;akfj dflkj But it exports as: dsfkdfjkfj ;akdfjdkjf ;kdjf df asldefj alskdjfk ;akfj dflkj Any way to fix this? Since one return works, why doesn't the second one? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formatting for mail merge
Maybe try alt + enterspacealt + enter?
Gord Dibben MS Excel MVP On Thu, 15 Apr 2010 12:46:01 -0700, rroswell86 wrote: When I enter text, then alt-enter, there is a "return" when I mail merge - but if I do another alt-enter to create a blank space, that one doesn't merge. Example in the excel cell, I type: dsfkdfjkfj ;akdfjdkjf ;kdjf df alt-enter alt-enter asldefj alskdjfk ;akfj dflkj alt-enter I want this to export as: dsfkdfjkfj ;akdfjdkjf ;kdjf df asldefj alskdjfk ;akfj dflkj But it exports as: dsfkdfjkfj ;akdfjdkjf ;kdjf df asldefj alskdjfk ;akfj dflkj Any way to fix this? Since one return works, why doesn't the second one? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I lose my number formatting in the mail merge? | Excel Discussion (Misc queries) | |||
| Maintaining currency formatting in a Mail Merge? | Excel Discussion (Misc queries) | |||
| How do I maintain cell formatting when I export to a mail merge? | Excel Worksheet Functions | |||
| Cell formatting in Mail Merge | Excel Discussion (Misc queries) | |||
| How do you keep Excel currency formatting during a mail merge? | Excel Discussion (Misc queries) | |||
Linear Mode
