Dec 03 2018 12:13 PM
Have cell with both text and numbers (including commas and periods-currency without currency formatting). Text varies in lenght and/or numbers vary in lenght. See attached image file.
Would like to move numbers, commas, and period(decimal) to a new cell in a new column.
In summary, separating text from numbers.
Dec 03 2018 12:25 PM
You may use the formula like
=VALUE(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1))))