Forum Discussion
Excel Formula
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...
You may use the formula like
=VALUE(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1))))
Thank you!