Archive

Excel: How to trim space before each cell in a column?

Hi Experts,

How can i remove a single space from the front of each cell in a Column.

I want a formula that i can use to remove one empty space in front of each words or words in the cell.

I have data as below

   Hand OK
  Techyv
  Com

You can see in the above table the start is a space. need to remove it

Thanks in advance

Srene

Read more
srinivas N/A Written on 04/15/2011 in Question

MS-Excel: How to alter data in a row to column?

Simple excel question. How can i convert a row of data into column

I have an excel in Row 1 i have 100+ cells of data.

I want to get them into a Column

Can anyone help me with a script or a inbuilt way to achieve this.

 

Read more
Shruthi N/A Written on 04/15/2011 in Question

RAM (Random Access Memory) – A Brief Overview

RAM (Random Access Memory) – A Brief Overview

Random Access Memory, abbreviated as RAM, is a common form of data storage in computers. At present, it is generally used in form of several integrated circuits, which enable the user to access the stored data in any "random" order. The word "random" has been used to convey the meaning that one can access and return any data piece at any time, irrespective of its location and relation with the previously accessed data piece. The term ‘RAM’ is, however, used more commonly to refer to volatile memory types; like DRAM modules, wherein...

Read more
Javen Gilderoy N/A Written on 04/15/2011 in Article

Six-Sigma –A Brief Introduction: Concept and Uses

Six-Sigma –A Brief Introduction

Developed in the year 1981 by Motorola, US, Six Sigma is the term used to refer to the popular strategy of business management used in various industries today. It aims at improving the process output quality by first identifying and then eliminating the various causes of errors (defects), thereby reducing the variability in the business and manufacturing processes to the minimum.

It employs various statistical methods and tools for quality management and develops a distinctive...

Read more
Sharath Reddy N/A Written on 04/15/2011 in Blog

Why are iPhone applications so expensive to code?

Why are iPhone applications so expensive to code?

Why are iPhone applications so expensive to code? iPhone is the latest buzz in the communication world. People can be ambivalent towards Apple, but it's impossible to be ambivalent about the iPhone these days.

The gadget is so cool that every hand needs to hold it but think for just one second that what’s the use of iPhone without cool applications? It is the compelling and attractive applications, which make the iPhone even better. In this connection, the developers have the big task to cope with the needs of...

Read more
Sharath Reddy N/A Written on 04/15/2011 in Blog

Opposing Operating System: Windows 7 over Windows Vista

Windows 7 vs. Windows Vista

Versions and Variations Windows 7 is the latest OS from Microsoft’s arsenal, the previous one being Vista.  There was a big hype when Windows 7 was released that its performance will be better manifold when compared to its forerunner Vista.

We will see here whether Windows 7 lived up to its expectations or not.  Also, we will see if Windows 7 is better than Vista and if so, how? Vista and its Flavors Windows Vista has many versions or flavors and the most extensively used four flavors are Windows Vista Home Basic, Windows Vista...

Read more
Sharath Reddy N/A Written on 04/15/2011 in Article

Top tips for Windows Server 2003

Top tips for Windows Server 2003 Some very useful shortcuts and tips for all Windows Server 2003 users. It is a fact that Microsoft takes us for granted! Yes you heard it, the company thinks that we can read their minds, but the fact of the matter remains that some things are best learnt when someone posts them on the internet!   Run As? Isn’t that dangerous! Tired of logging off and logging in again as a different user to run an application? Here’s the perk. Once a shortcut has been created of your program, right click it -> properties...

Read more
Sharath Reddy N/A Written on 04/15/2011 in Tips

Uses and functionality of Wireshark

Uses and functionality of Wireshark

What is Wireshark Wireshark is a free open source packet (network protocol) analyzer- the most popular in the world. Basically, what Wireshark does is that it captures all information related to network activity from a computer.

This information can then be used to perform important actions like troubleshooting and diagnosing any network performance difficulties. It was originally known as Ethereal until 2006 when the name was changed to Wireshark. Why is this used To understand why Wireshark is used, one needs to understand what exactly a network analyzer does. Essentially a network analyzer is...

Read more
Sharath Reddy N/A Written on 04/15/2011 in Blog

What is WAMPP and XAMPP packages?

What is XAMPP

There are a number of AMP type packages around. This article is aimed at explaining what exactly an AMP package, is, which packages are available, and take a more in-depth look at the XAMPP offering, and what differentiates it from the others.

AMP – What does this mean? The term AMP includes any software package containing the following:
  • Apache (the Web Server)
  • My SQL Server (the Database management system, or Database Server)
  • P – any of PHP, Perl or Python (All programming languages used in Web development)
So, AMP is an acronym, and refers to...

Read more
Sharath Reddy N/A Written on 04/15/2011 in Article

Wireless Technologies Era: Wi-max VS Wi-fi

Wi-Max versus WiFi

The human society has been divided into different ages and eras depending upon the different types of advancements, progress, and developmental stages of evolution through which it has passed during the course of the history.

The Paleolithic era, the Neolithic era, the stone age, the industrial revolution and the invention of steam engines, the modern times and now the post-modern contemporary times. However talking and discussing about the technological changes; in fact the birth of technology more specifically, the age of Information and Communication Technology (ICT) is characterized by the historians to have...

Read more
Sharath Reddy N/A Written on 04/15/2011 in Article