converting excel document word
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Converting an Excel document to a Word document

Converting an Excel document to a Word document

resolvedResolved · Urgent Priority · Version 2003

replyReply Tue 25 Aug 2009, 16:00Delegate Karen said...

Karen has attended:
Excel Advanced course

Converting an Excel document to a Word document

I in retrospect rather stupidly typed a lot of text in an Excel document but should have used Word. I copied the text to a blank word document but I am unable to delete spaces and extra lines where for example a sentence will stop mid way across a page and continue swy a couple of lines further down. It is driving me mas trying to correct it ! Can you help please.

For upcoming training course dates see: Pricing & availability

replyReply Tue 25 Aug 2009, 16:09Trainer Amanda said...

RE: Converting an Excel document to a Word document

Hello Karen

Thank you for your question and welcome to the forum.

A couple of things you could try:

1. Try copy and paste from Excel into Notepad, then Notepad into Word and see if that helps.

2. If this doesn't help, try copying and pasting into Word, and use the little Paste options button that comes up when you paste to select the option to paste Text only; see if that helps.

3. The third option would involve using Replace in Word to replace all the non-printing characters (line breaks etc) with a space instead. This is a little more involved. You will have to turn on the Show-Hide button in Word (looks like a back-to-front P and lives on your standard toolbar); then find for each of the different strange little symbols that appear between the letters EXCEPT for the symbols that appear as a single dot, copy the symbol, go to Edit - Replace, paste the symbol into the Find what box. Then for Replace with, click into the box and press the spacebar once.

This is designed to replace all the strange little extra lines etc with a single space. I hope this helps.

Kind regards
Amanda

Tue 1 Sep 2009: Automatically marked as resolved.

 

Please browse our web site to find out more about
advanced+excel+training+in+london and other Microsoft training courses.

Excel tip:

Adding up rows or columns without seeing formulas

Highlight a column or row and click the Autosum button. This gives you your answer without showing the formula.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard