i need to increment a numbered column when the data is in quotes

[Guest]

i use csv files very frequently, but need to create them in excel. see ex: below, excel will not increment the quoted contents in column B and C. the comma is merely a column seperator used by excel when saving the file as a cs
HELP

A B
","E601","300","A300
","E601","301","A301
","E601","302","A302
","E601","303","A303"

 

[Kevin Stecyk]

i use csv files very frequently, but need to create them in excel. see ex:

below, excel will not increment the quoted contents in column B and C. the
comma is merely a column seperator used by excel when saving the file as a
csv

HELP!

A B C
","E601","300","A300"
","E601","301","A301"
","E601","302","A302"
","E601","303","A303"

Todd,

I think you are making this more difficult than it need be.

In rows A B and C, have the the following:

601 300 300
601 301 301
601 302 302
....(extend down...drag the anchor)

Leaving Col F as blank.

In Col E...
="E"&A1

In Col F...
=B1

In Col G...
="A"&C1

copy on down as required.

Cols E:G are your solution. You can copy paste special - values, if you
like, and overwrite Col A:C. If you do overwrite Cols A:C with the hard
coded values, you can delete Cols E:G.

Save As YourFileName.CSV (Save as a CSV file type).

There is no need to put in all the commas. Excel will do that for you when
you save the document.

Hope that helps.

Regards,
Kevin