troubleshooting Question

Define lines in specific Microsoft Excel 2010 column cells that will be used in mail merge

Avatar of arendt73
arendt73 asked on
Microsoft ExcelMicrosoft WordSpreadsheets
4 Comments1 Solution434 ViewsLast Modified:
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.
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros