Monday, August 24, 2015
The INDIRECT function is very useful in case you have derived or calculated in a cell the cell reference from where you want the data from.
For Example, if cell A3 has a value C5 (May Be calculated based on some formula or logic) and you want to refer C5 from A3 to get the value of cell C5:
Thursday, August 20, 2015
Many times =Trim(Text) and =Trim(Clean(Text)) does not work in MS Excel to remove and clean leading spaces created due to non-breaking space (Char(160)) specially if you are copying data from web or bullet list in MS Word into an Excel Worksheet.
This problem can be resolved by :
=TRIM(CLEAN(SUBSTITUTE(Old Text,CHAR(160)," ")))