+ Reply to Thread
Results 1 to 1 of 1

Remove spaces and unwanted details from excel sheet

  1. #1
    Registered User
    Join Date
    Oftringen, Switzerland
    MS-Off Ver
    Professional Plus 2010

    Remove spaces and unwanted details from excel sheet

    Hi all

    I have an excel list that is a PDF export, currently, it contains spaces and spaces which make the info unusable in Excel.

    Is there a possibility of creating a macro/function that would clean up the exported output into a usuable format?

    For better understanding I have attached the exported excel file with two worksheets: Original and Required Output.

    The original shows the data as exported from the PDF and the Required Output shows the data format as needed.

    Looking forward to your assistance.

    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Can some one please help me with V.B.A code to remove the unwanted data in the sheet.
    By boddulus in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-08-2014, 12:30 PM
  2. [SOLVED] Remove unwanted rows in Excel 2010
    By kisboros in forum Excel General
    Replies: 11
    Last Post: 04-06-2013, 12:41 PM
  3. Replies: 8
    Last Post: 12-17-2012, 05:30 AM
  4. quick way to remove unwanted style in excel 2003
    By lelo in forum Excel General
    Replies: 5
    Last Post: 11-23-2011, 02:03 AM
  5. [SOLVED] How do I remove unwanted banner pages in excel workbook print
    By Johan in forum Excel General
    Replies: 1
    Last Post: 01-31-2006, 11:40 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1