seach and replace '(' with an '/'

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 someone could give me.
 
T

Tushar Mehta

Do you want XL to treat the result as a number or text?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
D

Dave O

I clicked >Edit >Replace, entered "Search For" ( then "Replace With" /.
Excel automatically converted the fraction to least common
denominator. Then I formatted the cell as numeric with 7 decimal
places and got your intended result. Does that work the same for you?
 
D

Dave O

Apologies, misread the post. Do you need the fraction to remain as it
originated, without reducing to least common denominators?
 
Top