There is no inbuilt function in Excel to remove all the text part from a string and get only the numeric part (or vice versa –  remove the numeric part and give only the text part from a string in a cell). However, this can be done using a cocktail of Excel functions. Let me show […]