cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
davehus Member
Member

Split column at first letter

Hi, I have a product code that contains numbers and text on the end, each has a differnt character length. Is there a way to split the column and the first instance of a letter to leave the numerical value?

 

Thanks.. : )

1 ACCEPTED SOLUTION

Accepted Solutions
gooranga1 Senior Member
Senior Member

Re: Split column at first letter

Hi @davehus,

 

This works very well.

 

https://www.excelguru.ca/blog/2015/11/19/keep-only-numbers-in-power-query/

 

Just tested it and it works like a charm.

 

remove values.PNG

 

 

View solution in original post

1 REPLY 1
gooranga1 Senior Member
Senior Member

Re: Split column at first letter

Hi @davehus,

 

This works very well.

 

https://www.excelguru.ca/blog/2015/11/19/keep-only-numbers-in-power-query/

 

Just tested it and it works like a charm.

 

remove values.PNG

 

 

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,276)