Forum

Split digit to non ...
 
Notifications
Clear all

Split digit to non digit in Excel 2016 using qury

3 Posts
3 Users
0 Reactions
105 Views
(@fatma-abdelatty38yahoo-com)
Posts: 1
New Member
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
Alan Sidman
(@alansidman)
Posts: 223
Member Moderator
 

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
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

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

Screenshot-2022-01-31-135226.png

See attached file.

 
Posted : 01/02/2022 8:58 am
Share: