Custom Number Format

  • Thread starter Thread starter Excelders
  • Start date Start date
E

Excelders

hi there,

I´ve got a list of equipments that are tagged with the company´
inventory number. Each item has its own tag which´s composed by eigh
characters and the first is separated by an "-" , like this example
*1-0012345*.

Unfortunately the list is generated by an old system that can hold onl
12 character tags and doesn´t support any other symbols.
Therefore, it puts a couple of ZEROS to replace the " - " symbol, an
another couple of ZEROS at the end to sum up 12 characters.
In the end the tags look like: *100001234500*.

How can I format the tag column to display the odd 12 characters in th
8 number fashion?
I guess it´s like saying to excel to replace the 2nd and 3rd number
with an " - ", and forget about the last two ZEROS.

Is that possible ?


TI
 
This might do it for you. Assuming that the tag number *100001234500* i
in cell A1, your formula in Cell B1 can be something like this

=left(A1,1)&"-"&mid(A1,3,7)
 
*-TYPO-* on the first formula that I gave you. It should be

=left(A1,1)&"-"&mid(A1,4,7)
 
Back
Top