Excel is great at working with both numbers and text—but if you’re using both in the same cell, you might run into some difficulty. Fortunately, you can extract numbers or text from cells to work with your data more efficiently. We demonstrate several options, depending on the format that your data is currently in. Numbers Stored as Text This is a common situation, and—fortunately—very easy to deal with. Sometimes cells that contain only numbers are incorrectly labeled as text, preventing Excel from using them in operations. You can see in the image below that the cells in column A are stored...
Read the full article: How to Extract a Number or Text from Excel with this Function
from MakeUseOf http://ift.tt/1IRvD2X
via IFTTT
No comments:
Post a Comment