Excel

• Convert numbers to different number systems

if match substr

my cells have unit in them... some MB , some KB, I want the mall to be a single unit so I can remove the uni and do math on it.

=IF(ISNUMBER(SEARCH("* MB",A1)),"dog","")

resources:

• http://www.techrepublic.com/article/using-excels-find-and-mid-to-extract-a-substring-when-you-dont-know-the-start-point/1033368
• http://www.techrepublic.com/article/save-time-by-using-excels-left-right-and-mid-string-functions/1033367

=LEFT(J3,LEN(J3)-(LEN(J3)-FIND(" ",J3)))