I am trying to copy results from custom Outlook forms into Excel. I noticed it works much better than in Access. The only problem I run into is that if there is a comment field and people hit the enter key in between lines in the comments field, it seems to mess up the way the info pulls into Excel.
I am thinking that Excel does not recognize the carriage returns.
Is there any way to get around this other than telling people to not use hit the enter button when making comments?
Thanks!
I am thinking that Excel does not recognize the carriage returns.
Is there any way to get around this other than telling people to not use hit the enter button when making comments?
Thanks!