Forum Discussion

gflory's avatar
gflory
Copper Contributor
Dec 03, 2018

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...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 03, 2018

You may use the formula like

=VALUE(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1))))
  • gflory's avatar
    gflory
    Copper Contributor
    Dec 03, 2018

    Thank you!

Resources