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

Hi

I would suggest trying Data/Text to Columns and using the Fixed Width
option.
Make sure you backup your sheet before you try!

Andy.

"sagiraju" wrote in
message ...

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

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