everydayExcel Newsletter Header

New Year, New Identify Emphasis, New Services

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 formulas.

extracted number recognised as text

When I try to sum up the 3 numbers in (B2:B4), it returns zero... more on numbers-displayed-as-text

Ask us an Excel question and get your question answered by our team of experts

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.

Subscribe to our newsletter

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.

Follow us at Facebook, LinkedIn

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.

Yours Sincerely,

Jason Khoo
Chief Trainer
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.