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

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.

Try this:

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

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=397372

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.