Prev: How do I increase numbers by 10%, 15% and 20%?
Next: stumped on creating dependent data validation lists
From: rroswell86 on 15 Apr 2010 15:46
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!
From: Gord Dibben on 15 Apr 2010 16:16
Maybe try alt + enter>space>alt + enter?


Gord Dibben MS Excel MVP

On Thu, 15 Apr 2010 12:46:01 -0700, rroswell86
<rroswell86(a)discussions.microsoft.com> 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!

 | 
Pages: 1
Prev: How do I increase numbers by 10%, 15% and 20%?
Next: stumped on creating dependent data validation lists