I have example of a hyperlink that is fragmented for use of inserting a
variable,
e.g.: HYPERLINK($U$5&O9&$U$7,"1")

Need O9 (variable) to be truncated of last three characters, so far have:
=IF(RIGHT(O9,3)=".pk",HYPERLINK($U$5&O9&$U$7,"1"), HYPERLINK($U$5&O9&$U$7,"1"))

(need fix for 1st hyperlink expression "O9", to lose last 3 characters if
".pk")
thanks in advance