Excel : Joining Two Text Columns

By -
Nice article : http://www.mrexcel.com/tip074.shtml


=PROPER(A2&" "&B2)

Comments

Post a Comment

Popular posts from this blog

Windows 10: The 10 best new features

By -
Image
The best of what's new Let’s not beat around the bush:  Windows 10 is wonderful . It’s head-and-shoulders better than Windows 8.1, at least for traditional PC users. The fact that it banishes full-screen apps and the Metro Start screen to the aether, focusing instead on the tried-and-true desktop, should be reason enough to  make PC purists smile . That’s just the tip of the iceberg, though. If you’re fresh to Windows 10, these are the cool new features you’ll want to check out first. source :  http://www.pcworld.com/                 http://www.pcadvisor.co.uk/   Windows 10  is upon us at long last. Whether you've updraded or not, here are the best 10 features of the upcoming operating system.  See also :  Windows 10 hands-on review . Microsoft had a lot to say during its January briefing and gave a look at what Windows 10 will look like in terms of end user features and the final version is...
Read more

JavaScript Comparison and Logical Operators

By -
Comparison Operators Comparison operators are used in logical statements to determine equality or difference between variables or values. Given that x=5 , the table below explains the comparison operators: Operator Description Example == is equal to x==8 is false === is exactly equal to (value and type) x===5 is true x==="5" is false != is not equal x!=8 is true > is greater than x>8 is false < is less than x<8 is true >= is greater than or equal to x>=8 is false <= is less than or equal to x<=8 is true     Logical Operators Logical operators are used to determine the logic between variables or values. Given that x=6 and y=3 , the table below explains the logical operators: Operator Description Example && and (x < 10 && y > 1) is true || or (x==5 || y==5) is false ! not !(x==y) is true         Source: http://www.w3schools.com/js/js_comparisons.asp
Read more

PHP Static modifiers

By -
<?php // static modifier // with static methods you can't use $this // this : talking about current instance // self : talking about current class class Student{ static $total_students = 6; static public function add_students() { //here you can use either Student or self. //but self is better because it's inside the Student class. self::$total_students++;// self : talking about current class. } static function welcome_students($var="Hello") { echo "{$var} students"; } } //$student = new Student(); //$student-> total_students; // echo Student::$total_students." "; // echo Student::welcome_students("Good bye")." "; echo Student::add_students()." "; //Student::$total_students = 1; echo Student::$total_students." "; /* -------- VERY IMPORTANT ---------- * static variables are shared throughout the inheritance tree * even if you assign different values inside ch...
Read more