Excel: Difference between revisions
From Federal Burro of Information
Jump to navigationJump to search
(Created page with " * [http://office.microsoft.com/en-us/excel-help/convert-numbers-to-different-number-systems-HA010010313.aspx Convert numbers to different number systems]") |
No edit summary |
||
| Line 1: | Line 1: | ||
* [http://office.microsoft.com/en-us/excel-help/convert-numbers-to-different-number-systems-HA010010313.aspx 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))) | |||
Revision as of 20:15, 23 August 2011
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)))
