Notifications
Clear all
Power Query
3
Posts
3
Users
0
Reactions
105
Views
Topic starter
Hi All,
I have 2500 rows of data ( XMATCHSALINE1$213.00 ). I want to split each one of them in a split column (colum1 includes XMATCHSALINE ),(column2 includes 1 )(column3 includes $213.00),using query and Excel 2016 doesn't include the option of a split from digit to non-digit
Any help, please
Thanks in advance
Posted : 01/02/2022 4:37 am
Would be extremely helpful if you uploaded a sample file of 10-15 records for us to work with.
Posted : 01/02/2022 6:04 am
Try by adding two columns using Text.Select. Once to keep only letters A to Z. Another to keep 0-9, the dollar sign and the decimal point. Then you can split the second column with $ as the delimiter (assuming that you'll have $ everywhere).
See attached file.
Posted : 01/02/2022 8:58 am