Clean and Extract Text the EASY Way - Pro Tip!

0:16 Introduction
0:42 Text.Select Lower Case Letters
1:28 Text.Select Upper Case Letters
1:48 Text.Select Numbers
2:12 Text.Select Letters and Numbers
2:52 Text.Remove Lower Case Letters
3:42 Text.Remove Upper Case Letters
3:51 Text.Remove Numbers
4:06 Text.Remove Letters and Numbers
4:28 Text.Remove Special Characters
5:35 Unicode Trick

[JimFikes]

Excellent tutorial. I really appreciate how clearly everything is explained and demonstrated.

[barbaraharris]

Thanks! I use your videos as a part of my weekly personal business training. You have taught me so much! Thank you!!!

[elbadlis]

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

[wayneedmondson]

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

[RoeGabriel_i_EMPOWER]

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

[MrDexter]

It is so crazy that this video just came out. I kid you not I just started a project that needed this as a solution. Thank you!

[sandyrgregory]

I have been looking for this for a long time.. Thanks for this tutorial...

[gloriasancho]

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

[thapashanu]

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.

[Luciano_mp]

Fantastic tip, great. Thank you Mynda!

[meniporat]

Thanks a lot, Mynda & Philip
Excel-lent, as usual.

[darrylmorgan]

Hi Mynda/Phil!Great Tutorial From Phil Really Well Explained...Thank You Both :)

[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!!!

[joeparris]

Super useful for so many scenarios. Thanks!

[vikranttyagi]

Thanks alot for all these great lessons.

[kiler]

Great Video! Can this technique be used if desired text is in another sheet? and is a table? Thanks!

[juja]

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

[labully]

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.

[masterboxxx]

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

[gauravgupta]

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