Here are the few useful websites info on using spreadsheets.
Extract a Substring Using the MID Function in Excel
Please go through below page for more details.
http://spreadsheets.about.com/od/Text-Functions/ss/2011-01-31-excel-2010-truncate-text-strings-mid-function.htm
http://spreadsheets.about.com/od/excel2010functions/ss/2011-01-30-excel-2010-truncate-text-strings-right-function.htm
Subtraction of two numbers:
column1 column2 output_column
12 14 =column1-column2
Enter the computational string "=column1-column2" in the column where you need the result of subtraction of two numbers. Since, we don;t have any function in function list like SUM and AVERAGE etc.
If I find anything new about using spread sheets then will add it here.
Extract a Substring Using the MID Function in Excel
Please go through below page for more details.
http://spreadsheets.about.com/od/Text-Functions/ss/2011-01-31-excel-2010-truncate-text-strings-mid-function.htm
http://spreadsheets.about.com/od/excel2010functions/ss/2011-01-30-excel-2010-truncate-text-strings-right-function.htm
Subtraction of two numbers:
column1 column2 output_column
12 14 =column1-column2
Enter the computational string "=column1-column2" in the column where you need the result of subtraction of two numbers. Since, we don;t have any function in function list like SUM and AVERAGE etc.
If I find anything new about using spread sheets then will add it here.
No comments:
Post a Comment