Clean and Extract Text the EASY Way - Pro Tip! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Srinivasan
Hi I have a question : I have a huge list of customers names that start with A to Z and I would like to filter those customers names starting from A to L and only show me other customers names starting with M to Z. Customer names starting from A to L is handled by Group A and Customers names starting from M to Z is handled by group B. How do I filter that using power query?
Thanks in advance..
reply
Hi I have a question : I have a huge list of customers names that start with A to Z and I would like to filter those customers names starting from A to L and only show me other customers names starting with M to Z. Customer names starting from A to L is handled by Group A and Customers names starting from M to Z is handled by group B. How do I filter that using power query?
Thanks in advance..
reply
Deborah
can you do a video on concatenation. I want to know how to create a text base template. I want to be able to build a template that my students fill in and then the summary of the text appear in another cell, only once the first set of cells have been completed.....could you do a tutorial like that please....thanks
reply
can you do a video on concatenation. I want to know how to create a text base template. I want to be able to build a template that my students fill in and then the summary of the text appear in another cell, only once the first set of cells have been completed.....could you do a tutorial like that please....thanks
reply
Gaurav
Thanks! wonderful tutorial, How can I get only text (Upper and Lower in the same sequence). I just want to remove the numbers and the special characters? Really appreciate your explanations
reply
Thanks! wonderful tutorial, How can I get only text (Upper and Lower in the same sequence). I just want to remove the numbers and the special characters? Really appreciate your explanations
reply
Carlos
Great tips. I really think that a native regular expression formula would be nice. I managed to use regular expression in PQ through JavaScript but it is very slow. Do you have any tips?
reply
Great tips. I really think that a native regular expression formula would be nice. I managed to use regular expression in PQ through JavaScript but it is very slow. Do you have any tips?
reply
Wayne
Awesome Mynda and Phil! Thanks for the tips and the explanation of the underlying unicode logic for Text.Select and Text.Remove. Very useful! Thumbs up :))
reply
Awesome Mynda and Phil! Thanks for the tips and the explanation of the underlying unicode logic for Text.Select and Text.Remove. Very useful! Thumbs up :))
reply
Monirul
Really like the way you explain things. I have learnt a lot from your tutorials but in one situation which I am not able to solve. Can you help please?
reply
Really like the way you explain things. I have learnt a lot from your tutorials but in one situation which I am not able to solve. Can you help please?
reply
hemanth
HI ..How can I remove a particular text from the column from query editor. For instance if I want to remove the word- city -from the text San Juan city
reply
HI ..How can I remove a particular text from the column from query editor. For instance if I want to remove the word- city -from the text San Juan city
reply
apamwamba
Cool...Thats what utilities like ASAP UTILITIES do so i can do this on my own now using Power Query....Very Cool indeed!! Thanks for the Knowledge!!!
reply
Cool...Thats what utilities like ASAP UTILITIES do so i can do this on my own now using Power Query....Very Cool indeed!! Thanks for the Knowledge!!!
reply
Keith
Good day Phil/Mynda. How can I set power query to display the contexual formula list or help window in Excel 2016 as shown in the video.
reply
Good day Phil/Mynda. How can I set power query to display the contexual formula list or help window in Excel 2016 as shown in the video.
reply
thomasscariav
Hi, Thanks for this video! In the last example to extract number how to convert the column to number datatype in the same step?
reply
Hi, Thanks for this video! In the last example to extract number how to convert the column to number datatype in the same step?
reply
Add a review, comment
Other channel videos
