Format Cell value...
 

We have a program we use in manufacturing, and are now required to export
data to Excel. Our part number needs to have a particular structure.
(123456_blah_blah) but there is only the 123456 and the second blah. Nothing
i the middle. Is there away for Excel to fomat this during or after the data
has been exported.

Thanks
David

Format Cell value...
 

are you exporting to a csv file? are the parts of the part number separated
by underlines? open the import file in notepad and show us what it looks like

"116" wrote:

We have a program we use in manufacturing, and are now required to export
data to Excel. Our part number needs to have a particular structure.
(123456_blah_blah) but there is only the 123456 and the second blah. Nothing
i the middle. Is there away for Excel to fomat this during or after the data
has been exported.

Thanks
David

Format Cell value...
 

The export file is an 'xls'. There would only be dashes in the part number.

"dlw" wrote:

are you exporting to a csv file? are the parts of the part number separated
by underlines? open the import file in notepad and show us what it looks like

"116" wrote:

We have a program we use in manufacturing, and are now required to export
data to Excel. Our part number needs to have a particular structure.
(123456_blah_blah) but there is only the 123456 and the second blah. Nothing
i the middle. Is there away for Excel to fomat this during or after the data
has been exported.

Thanks
David

Format Cell value...
 

The program you use in manufacturing exports as an Excel file?

Which program would that be?

Give an example of the data the program sends to Excel and what you want to
display in Excel.

Forget blah_blah............give us an actual example or two.


Gord Dibben MS Excel MVP


On Mon, 15 Dec 2008 05:46:01 -0800, 116
wrote:

The export file is an 'xls'. There would only be dashes in the part number.

"dlw" wrote:

are you exporting to a csv file? are the parts of the part number separated
by underlines? open the import file in notepad and show us what it looks like

"116" wrote:

We have a program we use in manufacturing, and are now required to export
data to Excel. Our part number needs to have a particular structure.
(123456_blah_blah) but there is only the 123456 and the second blah. Nothing
i the middle. Is there away for Excel to fomat this during or after the data
has been exported.

Thanks
David