I received a shapefile about invasive species. I am using ArcGIS 10.2 for desktop. In Attribute Table, there is column called "Infested_Area" and its got number mix with text, for instance "9100 sq feet". Since I can not run statistic on string I was wondering if it's possible to create a new filed and somehow get rid of the text portion of it and only have number!
This is similar to @PolyGeo solution
but will handle different units and unitless entries
Note you cannot run statistics on result, if units are different
If your text field (mine is called TextField) always has the same string after the number like below then you can add a number field (mine is called IntegerField).
Then in the Field Calculator set the Parser to Python and use this as the expression to calculate your number field.
int( !TextField!.replace(" sq feet",""))
You should see the text stripped off in the output values for your number field.