Clean and Extract Text the EASY Way - Pro Tip!

Thank you for this. It's very helpful. Are you able to please suggest a solution for an alphanumeric string that I need to clean up and convert to number. It's a banking record. It has a "C" at the end to represent a credit. For instance, 800.00C is meant to be -800.00 on the bank statement. (900.00 is as stated (i.e., debit 900.00). So in this instance, I would like to keep the 900.00 as is and convert all numbers that have a C at the end to a negative number. Thanks for any assistance you can provide.

Thanks

Thank you very much. I am trying to extract a specific character string of seven characters that starts with a six that is in a text field the size of a large paragraph. I cannot figure out the code to extract when it is starts with a six and those seven characters.

oh man this is awesome!!! Thanks for tying in the explanation with ASCII - it TOTALLY makes more sense now.

Well done. Thank you.

Please, which version of excel is this?

How to remove only first for ex 3 characters?

Ma'am in power query, How to solve the problem of 1000 rows limit reached in filter option as I filtered my data but it was applied only on 1000 rows & not working on after 1000 rows.

Thank you for sharing such a valuable knowledge. The unicode trick is gold. Thanks, Mynda and Phil!

really amaaaaaaaaaaaaaaaaazin ,, thanks a lot ,, quite voice ,, striate forward without more intro pulse many many info in few minutes ,, really thanks

Great explanation! Super useful!

Unicode tip was very helpful

Was searching for some other solution and stumbled upon this video. Helped me solve a problem I was banging my head around for the last three days.

I don't have intellisense when adding custom columns, is this just due to my old excel version (2016) or is there a way to enable it?

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?

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

Fantastic!

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

You are awesome! It looks like game when you present it : )

Hi Mynda/Phil! Thanks for the video. It really helped me with a special project.