Use MicrosoftÂ® Excel Differently to Gain a Productive Edge
Issue - Nov 2012
Assuming that you have a range of cells containing
containing both texts & numbers within the same cell. You would like to extract the numbers for
some calculation, such as addition.
When you apply the formulas LEFT, MID or RIGHT to the range of cells, Excel immediately
present the extract numbers as text. In the example below, I have extracted numbers from Column A using
When I try to sum up the 3 numbers in (B2:B4), it returns zero... more on numbers-displayed-as-text
Here's a question from our members:
I have a column in which I enter numbers e. g. 1 2 3 4 5 6 7 8 9 10 as on. Suppose if I remove /deleted any number e. g. 3, then further columns should automatically adjusted as 3 4 5 as on. PLEASE refer attached sheet, so you will get exact idea what do I want. THANKING YOU.
If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.
If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and
"Excel Secrets for Highly Effective Marketers"
Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.