http://www.perlmonks.org?node_id=715128


in reply to Re: Internal links in Excel
in thread Internal links in Excel


Thanks Animator!!!

Your solution works!!

Replies are listed 'Best First'.
Re^3: Internal links in Excel
by Anonymous Monk on Jun 28, 2013 at 16:02 UTC
    'BATSOPLINK'!A1 this is the output I get when I try to print it via my $url = "internal:'$val$i'!A1"; Want to get rid of "!A1" and just want to print the value which refers to the cell