Skip navigation
LARBONATOR
Currently Being Moderated

Space Disappears when Converting to Excel

Jul 17, 2013 1:49 AM

Tags: #pdf #converting

Dear community, I require assistance! The issue here is that when I convert my pdf to excel the consecutive spaces in between disappears. I'd like to know if there are any methods that would allow me to convert and yet retain the space.

 

I have attached a screenshot as reference.

 

Any assistance is much appreciated!

 
Replies
  • Currently Being Moderated
    Jul 17, 2013 1:56 AM   in reply to LARBONATOR

    To attach a screen shot, you will need to use the CAMERA icon in the forum page. No other method works. We look forward to seeing it.

     
    |
    Mark as:
  • Currently Being Moderated
    Jul 17, 2013 2:31 AM   in reply to LARBONATOR

    Ok, that's a screen shot of a PDF, I guess.

     

    First you should understand that a PDF doesn't really contain spaces at all in many cases - just words, some of which are further apart. So converting text -> PDF -> text cannot be expected to do a perfect job (and PDF is a terrible way to distribute text for reuse).

     

    I don't know what you get in Excel, but Acrobat's probably doing the best it can.

     
    |
    Mark as:
  • Currently Being Moderated
    Jul 17, 2013 2:33 AM   in reply to Test Screen Name

    Though we should ask, in case it can be improved:

    - which version of Adobe Acrobat (or Adobe Reader) are you using?

    - how do you convert to Excel (step by step)?

     
    |
    Mark as:
  • Currently Being Moderated
    Jul 17, 2013 9:53 AM   in reply to LARBONATOR

    The PDF doesn't look like an excel file unless it’s a CVS  file.

    In that cits either Comma separated or Tabb separate file.  In that case you might get what you are getting.

     

    If an Excel file in a xlsx file format  is turned into a PDF.  And then turned back into a PDF by choosing:

    Save As Other  > Spreadsheet  > Excel Workbook.  It will pretty much revert complete Excel Format  that looks like the original. You might have to do minor formatting but it will look like an original.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points