Can I remove last 3 characters in portion of a link?
You can embed the if statement into the body of your formula:
=HYPERLINK($U$5&IF(RIGHT(O9,3)<".pk",O9,LEFT(O9,L EN(O9)-3))&U$7,"1")
nastech wrote:
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
--
Dave Peterson
|