Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

labels

ResolvedVersion 2016

Jane has attended:
Word Intermediate course
Word Advanced course

Labels

Please can you tell me how to copy and paste addresses from a Word perfect document into an excel spreadsheet. I can normally do this but when i have used the Control C and Control P functions to do this, the addressed is copied onto multiple cells rather than into just one cell. Please can you advise how I can copy and paste an address into just one cell so that i don't have to retype the whole list. Thank you.

RE: Labels

Hi Jane,

Thank you for the forum question.

You can paste multiple lines in one cell.

if you click in the cell or on the formula bar so you see the blinking cursor and then paste you will have multiple lines in one cell. it is more time consuming because you can't do many fields at once.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 25 Apr 2017: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Word tip:

Save Multiple Documents

If you have two or more documents open at a time but you don't want to go through the rigmarole of saving them one at a time then you can close or save them all in one go.

Hold down the Shift key and go to the File menu

Two new commands, Save All and Close All appear

One click and all of your open documents will be saved or closed.

View all Word hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.