Forum Discussion
Rhk_5
Jul 06, 2022Copper Contributor
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.
Rhk_5 See attached.
1 Reply
- Riny_van_EekelenPlatinum Contributor