Define lines in specific Microsoft Excel 2010 column cells that will be used in mail merge
I want to create a cell column (column C will have house mailing addresses) with a defined width and height that allows up to four lines in a cell. Is it possible if a person hits enter in the specific cell, it does not jump to the next cell, but goes to the next line in the cell?
For example, I type 100 Anywhere Street and hit return. It takes me to the next line in the same cell where I would type Suite 12345. I hit return and it takes me to the next line and type in Baltimore, MD 21236.
After completing this process, I want to mail merge (column C) into Word. Is this possible using my desired request?
Any suggestions and recommendations is greatly appreciated. Thank you.