Excel

From Federal Burro of Information
Revision as of 20:15, 23 August 2011 by David (talk | contribs)
Jump to navigationJump to search

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:

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