i have data like this
1-56
1-58/2
1-89/2a
1-59
1-56(2)
i want to separate this as like
1---56
1---58---2
1---89---2a
1---59
1---56---2
please help me about this as early as possible


--
sagiraju
------------------------------------------------------------------------
sagiraju's Profile: http://www.excelforum.com/member.php...o&userid=32739
View this thread: http://www.excelforum.com/showthread...hreadid=525708