Can I "translate" č, š, ž to c, s, z? : r/excel
Say one output is in J2. Make a little table in M2:N4 of: M N č c š s ž z. Then, K2: =CONCAT (IFNA (VLOOKUP (MID (J2,SEQUENCE (4e4),1),M2:N4,2,0),MID (J2,SEQUENCE (4e4),1))) This particular example depends on an O365 license, specifically for SEQUENCE. Thats not the only method, so if you go for this and get a #NAME! error, we can work around.