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

S

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

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