ExcelDemy.com Blog

0

LEN function in Excel

LEN function Syntax in Excel LEN (text) Example: LEN (“Annual Report 3 Dec, 2013”) In simple language the above example tells Excel to do: Return the number of characters of “Annual Report 3 Dec,...

0

RIGHT function in Excel

RIGHT function Syntax in Excel RIGHT (text, [number_of_characters]) Example: RIGHT (“Annual Report 3 Dec, 2013”,3) In simple language the above example tells Excel to do: Return the last 3 characters of “Annual Report 3...

1

SUBSTITUTE function in Excel

SUBSTITUTE function syntax in Excel SUBSTITUTE(text,old_text,new_text,instance_num) Example: SUBSTITUTE (“Annual Report 3 Dec, 2013″,”3″,”4”,2) In simple language the above example tells Excel to do: Substitute 2nd (instance_num) 3 (old_text) with 4 (new_text) in Annual Report...

0

Data clean-up techniques in Excel: Joining columns

Download this sample file to work with Joining in Excel Sometimes you may want to join two columns. To do this you can use concatenation operator (&) in a formula. For example, the following...

2

VLOOKUP Function in Excel: Learn with Examples

VLOOKUP Function: Overview VLOOKUP function is used to search in a list/ database with a value reference. See the following image. VLOOKUP Function: Syntax VLOOKUP (lookup_value, table_array, col_index_num, range_lookup) VLOOKUP Function: Example In above...

0

Data clean-up techniques in Excel: Classifying values

This article requires that you know Data clean-up techniques in Excel: Transforming Data with Formulas Sometimes it may be necessary that you will classify the values into a group. For example, if you have...

0

Data clean-up techniques in Excel: Converting values

This article requires that you know Data clean-up techniques in Excel: Transforming Data with Formulas Sometimes you may need to convert values from one metric system to another metric system. For example, you may...

0

Splitting Text in Excel Using Flash Fill

The Text to Columns Wizard works very well for many types of data. But some data can’t be split by this wizard. For example, you can’t split data if it is not fixed width...