Hi
I have following dataset
Input
0.4DB
2,99,99,00CR
0.00
4.2DB
26,700CR
0
150.00DB
EXPECTED OUTPUT all strings and numbers should be shown in seperate column, since i have multiple columns i would like use formula or regex tool
0.4 DB
2,99,99,00 CR
0.00
4.2 DB
26,700 CR
0
150.00 DB
Solved! Go to Solution.
is it possible to parse without using text to columns
just using formula tool to create numbers and string as separate columns