98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Word Training and help » Labels
Labels
Resolved · High Priority · Version 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Word tip:Assign shortcut keys to stylesIf you're a fan of using styles, you can create your own shortcut keys to apply styles quickly. |