Forum Discussion
Solved
ICD 10 codes
Hello! I am trying to add a period after the third character in the ICD codes but if there are no characters following the third character, I do not want to add a period. I have a picture of a sa...
OliverScheurich username965 i suspect there is a space after the 3 character codes so try one of these:
=IF(LEN(TRIM(D2))<=3,D2,REPLACE(D2,4,0,"."))EDIT: I created different 2nd option
=IF(MID(D2,4,1)<" ",D2,REPLACE(D2,4,0,"."))
Does it work in the attached file and is the data in the left column of your screenshot the start data and the data in the right column the expected result?
Thank you so much for your help!!