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

arendt73
arendt73 used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Use Ctrl-Enter instead of only Enter
Most Valuable Expert 2011
Awarded 2010

Commented:
No, ssaqibh, it's Alt-Enter to create a line break in a cell.

Ctrl-Enter will enter the formula bar content into a selected range of cells.

cheers, teylyn
Most Valuable Expert 2011
Awarded 2010
Commented:
@arendt73,

If you are planning on using the data for a mail merge in Word, I'd strongly suggest that you create separate columns for separate address lines. Word has the tools to ignore empty cells and create a contiguous address block, even if not all address fields have content.

Introducing an Alt-Enter character into a cell may be counter-productive when attempting the mail merge with word. So better use several columns, as many as required for "AddressLine1", "AddressLine2", "AddressLine3", "City", "ZipCode" etc.

Then use the Word Mail Merge tools to skip blank cells on merging.

cheers, teylyn
Oops....+1 to you teylyn

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial