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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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"
 
i use csv files very frequently, but need to create them in excel. see ex:
Click to expand...
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"
Click to expand...

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
 
Back
Top