+ Reply to Thread
Results 1 to 2 of 2

CSV import issue, Urgent help.

  1. #1
    Registered User
    Join Date
    07-22-2013
    Location
    Phl
    MS-Off Ver
    Excel 2007
    Posts
    3

    CSV import issue, Urgent help.

    Here is a screenshot. Its just a snapshot after an import of csv file to a excel template file. Everything comes out correct and in proper position except these text(as seen in image). If you look in this picture, Production volume, has to be in the middle column C and D as it is in original file, and its also correctly positioned in csv. But when I import it moves the text like that. Similarly, in row14 column B, Actual text is figures for next 7 days which has to be in the center as it is in original file which I copied before importing csv here.

    Why it could be? and how this problem can be resolved?

    My settings when I import are, (mentioned in the sequence of events)
    Delimited,
    Start Import row 1, File origin. 437 United States,
    Delimiter, Comma (only).. Nothing at all selected.
    Column data format General (for all columns),
    Import Data properties, Checked ones Save query Preserve cell formatting (As I have template, which has rows with diff colors) Overwrite cells

    Thanks alot.
    Sal
    Untitled.png

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: CSV import issue, Urgent help.

    cant tell from an image are the cells merged? what happens if you click in one? what does it show in the formula bar
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ 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. Excel import, CSV help urgent.
    By Saddy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2013, 12:15 AM
  2. Urgent Name Match Issue for Wrk - Anyone Help?
    By jonpsu22 in forum Excel General
    Replies: 5
    Last Post: 04-27-2011, 09:06 AM
  3. need urgent help: completely lost/stuck with vlookup issue
    By jimmyjj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2006, 10:35 PM
  4. [SOLVED] Import/Export Proble. Urgent
    By axissm in forum Excel General
    Replies: 1
    Last Post: 02-19-2006, 02:50 PM
  5. URGENT!! Import File Results in Error
    By greenfalcon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2005, 03:10 PM

Tags for this Thread

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