Jump to content

MS Excel Text to Columns Warning: There's already data here. Do you want to replace it?


Recommended Posts

Posted

Running PVsyst v7.4.2

Generate 8760 CSV output file using default settings.

Open 8760 CSV output file in Microsoft MS Excel.

Highlight first column (Column A).

Data tab > Text to columns > Delimited > Next > Semicolon > Finish

Warning: There's already data here. Do you want to replace it?

Because there's some data in columns B and C.

I don't think there should be data in any column except for Column A.

Thanks.

  • 7 months later...
Posted

I had this same problem with batch output files.  There is data in every column A, but sometimes also in B or C.  

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...