One way:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1, "-", "---"), "/",
"---"), "(", "----"), ")", "")

In article ,
sagiraju
wrote:


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