SOLVED

How to separate numbers, decimal numbers and text

Occasional Visitor

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

Example -

Cost-and-currency

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)
Solution

@Rhk_5 See attached.