wanted help about text functions

S

sagiraju

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 possibl
 
M

Mr.KZA

You want to group them into three columns, right? I'll try to search
info on it. But, currently, I also have no idea.
 
G

Guest

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.
 
J

JE McGimpsey

One way:

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

Beege

sagiraju said:
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
Click to expand...

sagiraju

You could search/replace

search "-", replace "---"
search "/", replace "---"
search "(", replace "---"
search ")", replace ""

Beege
 
Top