Excel Formula

Copper Contributor

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.

2 Replies

You may use the formula like

=VALUE(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1))))

Thank you!