Format Cell value...

  • Thread starter Thread starter 116
  • Start date Start date
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Format on Imported Data 3
Mail Merge Formating Issues 3
Removing Extra Details From Cells 2
Format cell - Miles 5
How to split up bulk text?????? 5
Access Access variable string for export 0
Excel 2007 Format issue, colons being substituted for decimals. 1
Date Formatting 2

Back
Top