I need an excel function that will help me split the numerical values from the alphabetical values and will return them into different cells.
For example, Cell A1 containts “999999 Salaries & Wages-Regular-Management”, I need the numerical value to be in one column and the alphabetical values...