Forum Discussion

Rhk_5's avatar
Rhk_5
Copper Contributor
Jul 06, 2022
Solved

How to separate numbers, decimal numbers and text

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.

Resources