Format Cell value...

1

116

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
 
D

dlw

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
 
G

Gord Dibben

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
 
Top