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

[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

[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")

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

[nastech]

awsome, thanks much..

"Dave Peterson" wrote:

> 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")
>
> 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
>