| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
| Excel Auto-Format cell to email format | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Linear Mode
