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

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

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

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

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,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