Output a parts list to a comma delimited text file

[megnin]

I'm making a parts ordering tool that will generate a list of parts. I'm made it put the parts list in another sheet listing each part and part# on a separate row.

Now they want the parts list in an exportable format listing all the parts and part#s in a single cell as a comma delimited list.

The problem is that they also want the tool compatable with Excel '95 which can only hold 255 characters in a single cell.

Is there a way to generate a text file with the parts list in a continuous comma delimited format?

The tool will have various combo boxes etc. to select the parts and I need them populated into the list as (or after the fact if it's easier) they are selected.

Thanks for any advice!!
David
megnin@nortelnetworks.com

 

[BigC]

Doesn't saving the sheet of extracted parts & part Nos in CSV (comma delimited) format (Save As CSV) achieve what you're after?

BigC

 

[kanga]

Hi Perthite,

As I understand it you want to merge two columns into a third column with a comma delimiter in between.

If that's the case then I think the following will work.
With column a = description, column b = number, and column c = combination of a and b with a delimiter.

C1=A1&","&B1

Hope I've understood the problem correctly.

Cheers

Peter

 

[megnin]

As I mentioned, I need the output in a single cell or possibly a text file with a simple string of parts separated by commas.

The tool it needs to be imported into will not take a spreadsheet or a column.

Thanks for any advice.

 

[megnin]

Oh, I know how to put the parts list in a single cell, but to be compatable with Excel '95 I would have to keep it under 255 characters. Since the list would surly exceede 255 characters I think my solution is to ouput it into the text file containing a simple string of parts separated by commas, no line feeds or anything else.

I don't know how to make Excel create a text file.

Thanks again.