Archive for the ‘Excel’ Category

Newer Entries »

Excel: How to combine or join text into one cell?

May 27th, 2011 by @HKw@! | No Comments | Filed in Excel, Ms Office

My friend asked me a question on how to merge First Name and Last Name into a single column in Excel instead of copy and paste the content from Column A and Column B to Column C 1 by 1. To solve his problem, they is a simple way to do that by using Concatenate function in Excel.

In Excel, the Concatenate function allows you to join character strings from several cells together in another destination cell.

The syntax for the Concatenate function is:

Concatenate( text1, text2, … text_n )

n = Up to 255 text entries can be added and entry must be separated by a comma. (more…)

Share

Tags: , , ,

Excel formula Errors

November 25th, 2010 by @HKw@! | No Comments | Filed in Excel, Ms Office

Sometimes your Excel formula may return an error message. Before you know how to correct or hide formula errors. The first thing you should know is to understand what each error type means.

Below are few possible error types:-

#Name?

- Means that you entered something in your formula that Excel interprets as an incorrect reference cell, range or function name.

#REF!

  • Indicates that you might have relocated or deleted a cell that is referenced in the formula.

#Value!

  • Tells you that you are probably usingtext in a formula when another argument (probably a number) is required.

#DIV/0

  • Occurs when you divide a number by zero or divide by a reference to an empty cell

#NUM!

  • Occurs when you try to pass an incorrect argument, like text, to a function that is expecting a numerical value
######
  • means that a number is too wide to be displayed in the cell
If you wish to know more information about Excel functions  and fix the error message, just google it. :-)
Share

How to use Absolute and Relative Cell in Excel

November 9th, 2010 by @HKw@! | No Comments | Filed in Excel, Ms Office

In Excel there are two types of cell references, these are Relative and Absolute.

An absolute cell reference consists of the column letter and row number surrounded by dollar signs ( $ ).

A relative cell reference consists of the column letter and row number that intersect at the cell’s location . Relative ranges do not use the $ character.

The $ character indicates to Excel that it should not increment the column and/or row reference as you fill a range with a formula or as you copy a range.

In summary, most cell references in a spreadsheet are relative cell references, which change when copied and pasted to other cells.Whereby absolute cell reference does not change when it a formula is copied and pasted to other cells. (more…)

Share
Newer Entries »
BlogCatalog