Well, I'd strongly suggest that you reconsider doing so. Jamming multiple
data items into a single cell seriously restricts how you can use/access the
data & may even prevent you from doing what "should be" simple point 'n'
click functionality... And once entered improperly trying to untangle it
after the fact is a real hassle. Have a look at Step 1 under the Excel Help
Topic: Create and print mailing labels. It sounds like what you're
attempting to do is set up mailing labels, but that approach will not work.
You'll do much better to store each data item [First name, last name, street
address, city, state, zip, etc.] for a record as separate fields (individual
cells) on the same row. The data will be much easier to maintain & will
serve you far better in the long run. It will also be usable with Word's
Mail Merge features for producing labels, envelopes, form letters as well as
catalogs or other merged documents.
If it were just a mater of needing to store paragraph text rather than
addresses or other data, line breaks in a cell can be created by using
either Command+Option+Return or Control+Option+Return.
HTH |:>)
Bob Jones
[MVP] Office:Mac
