I think I this conversion may not be so tough to make.
First we peel off the first three characters simply by using the
=LEFT() function, then store that in an adjacent cell. Then peel off
the "06" part by using the =RIGHT() function and store that in another
cell. Then use the CONCATENATE function to join the contents of the
first cell, plus a dash, plus the contents of the second cell.
Taking it a notch further, you can nest the RIGHT and LEFT functions
within the CONCATENATE function, and not have to store those substrings
at all.
-Dan
--
vthoky
------------------------------------------------------------------------
vthoky's Profile:
http://www.excelforum.com/member.php...o&userid=34607
View this thread:
http://www.excelforum.com/showthread...hreadid=543784