Can I remove last 3 characters in portion of a link?

N

nastech

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
 
D

Dave Peterson

You can embed the if statement into the body of your formula:

=HYPERLINK($U$5&IF(RIGHT(O9,3)<>".pk",O9,LEFT(O9,LEN(O9)-3))&U$7,"1")
 
N

nastech

awsome, thanks much..

Dave Peterson said:
You can embed the if statement into the body of your formula:

=HYPERLINK($U$5&IF(RIGHT(O9,3)<>".pk",O9,LEFT(O9,LEN(O9)-3))&U$7,"1")
Click to expand...
 
Top