how do i replace ( with / without changing format to fraction

[Guest]

I have a text field with a '('.
ex: 125 108(130

I want to replace the '(' with a '/' without changing the format of the
field to a fraction so my result would be '125 108/130' instead of changing
it to
'125.8307692'

Would appreciate any help you could give me.

 

[Flintstone]

Try this:

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

Mat

 

[Guest]

Here's one way:

If A1= 125 108(130
In A2 you would have:
=CONCATENATE(LEFT(A1,FIND("(",A1,1)-1),"/",RIGHT(A1,LEN(A1)-FIND("(",A1,1)))