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,"."))
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,"."))
The first formula worked perfectly! Thank you so much!