Mar 10, 2014 #1 luxvivens Technical User May 20, 2010 27 CA I am using CR10. I have data as follows: (fieldname.ICD10): OSRA90.23BC OSRA22.55JX I wish to convert these values to: OSRA9023BC OSRA2255JX Need help with a formula to do this.
I am using CR10. I have data as follows: (fieldname.ICD10): OSRA90.23BC OSRA22.55JX I wish to convert these values to: OSRA9023BC OSRA2255JX Need help with a formula to do this.
Mar 10, 2014 #3 SMMDJD IS-IT--Management Mar 10, 2014 4 CA Thanks kray. I replaced the comma with a . and it worked perfectly. Upvote 0 Downvote