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

[Splt Window Diner]

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,"(","/")

Matt

[Tom Hayakawa]

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)))


"Splt Window Diner" wrote:

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