Alright, you've gotta be aware that in Excel you can dispaly formats of a cell any way you want so a cell accepts two different textual info, like a formatted "Example Name" followed by an unformatted <<Variable_input>> as in your example. But whether that can be done through Perl, I doubt, I can not recall anything in the Spredsheet::WriteExcel module documentation that testified to this conjecture, to avoid the alignment issues use the merge_range(); instead of write() method of $worksheet.. I have come up with this code, to show the merging thing, thus solving a part of your question, as for the other part, I had to circumvent my way around and make the variable display on the right of the cell and below the "Example Name" line

#!/usr/local/bin/perl


use strict;
use warnings;
use Spreadsheet::WriteExcel;

my $workbook=Spreadsheet::WriteExcel->new('excel.xls');
my $worksheet=$workbook->add_worksheet('');

my $var= "biohisham";

my $bold=$workbook->add_format(
                                bold=>1,
                                align=>'center',
                                valign=>'vcenter',
                                size=>   15  #font_size

                                );
my $var_format=$workbook->add_format(
                                      align=>'left',
                                      valign=>'right',
                                      size=>15
                                      );

$worksheet->set_column(0,1,30);
$worksheet->set_row($_, 30) for (1,2);


$worksheet->merge_range('A1:B2',"Example Name:", $bold);
$worksheet->merge_range('A3:B3',"\b$var", $var_format);
[download]