making new option value column from 2 columns

i have this excel file which contains 2 columns of city names and city code i wanted to make from this 2 columns a new column with this  code

<option value=960>city name </option>

and i found this useful formula (thanks to jamal)

=CONCATENATE(“<option value=”,A2,”>”,B2,”</option>”)

when u put this code in the new column and copy them to the rest of the rows by pressing twice on the + sign .

Advertisements

Date formatting not working after installing qTranslate

after installing qtranslate:

Posted on %e de %B de %Y by johnny

I found a solution for this on the qTranslate forums:

Edit qtranslate_utils.php, line 151 from this:
$date_parameters[] = ‘#%#’; $strftime_parameters[] = ‘%%’;
to this:
$date_parameters[] = ‘#%#’; $strftime_parameters[] = ‘%’;

It seems the extra percentage sign makes it so the percentage sign in the format gets interpreted as literal percentage signs and therefore they don’t get parsed by strftime().

office 2013 Activation

to anyone like having trouble activating here what you need:

How to change the product key of Microsoft Office?

Click on the button to open the Start Menu. Now, click on the Control Panel and then click on Programs (Uninstall a program), and finally click on Program and Features.
(Windows XP users: Start > Control Panel > Add or Remove Programs.)

From the list of installed programs, find Microsoft Office Professional Plus 2013 . enter this key:
(GW6J7-PXNRV-RDX9M-FFMFD-PYQ6X)
select it and then click on Change.

From the newly opened dialog box, select the Enter a Product Key option, and then click Continue.

Type your new product key
(GW6J7-PXNRV-RDX9M-FFMFD-PYQ6X)
and check the option that says Attempt to automatically activate my product online to automatically activate your Office 2013 .
Now click on Continue and then on Install Now.

that’s it good to go.