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!

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!