+ Reply to Thread
Results 1 to 2 of 2

Importing Tabular info

  1. #1
    Registered User
    Join Date
    04-05-2008
    Posts
    1

    Smile Importing Tabular info

    I am importing tabular information direct into Excel. However, I want to get the spreadsheet to ignore certain column's automatically without manual intervention. How do I do it?

    Anyone know how?

    Thanks

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Quote Originally Posted by Boro
    I am importing tabular information direct into Excel. However, I want to get the spreadsheet to ignore certain column's automatically without manual intervention. How do I do it?

    Anyone know how?

    Thanks
    Hi,

    If you're referring to .csv or .prn files, then the import wizard allows you to select columns that you don't want to import. If you don't want to do this manually you could have a macro perform the same steps.

    HTH

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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