How to separate numbers, decimal numbers and text

Occasional Visitor

My table has a Cost-and-currency, where users can add values.

Example -


12.34 USD 

15 EUR

100 INR 


So I need to separate those numbers, decimal numbers and text into separate columns, like this 


Cost-and-currency     Cost       Currency

12.34 USD                  12.34        USD

15 EUR                        15            EUR

100 INR                        100         INR


* I know to do it using text to column, I need to do it using formula.

By using formula only.

1 Reply
best response confirmed by Rhk_5 (Occasional Visitor)

@Rhk_5 See attached.