SUBSTITUTE

Learn Excel 2010 – “Sakai Grade Book Point Extraction – Part II of IV”: Podcast #1542

               

Manipulating the Sakai Data WITHOUT using a VBA Macro.

Dueling Excel – “Remove Duplicates If…”: Podcast #1532

               

Can a Formula alone solve this?

Learn Excel – Clean But Not Too Clean: Podcast #1373

               

Remove the return but keep the space in Excel

Removing Name – 1097 – Learn Excel from MrExcel Podcast

               

Shift-Del sends in some alternative formulas to solve the problem from episode 1043. To see uses of SUBSTITUTE and REPLACE in Excel, check out Episode 1097. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377(…)

Episode 536 – Indeterminate Substitution

               

Robbie calls in today to ask how to add a hyphen at an unknown position in each cell. For example, whenever Excel finds a period, add a dash. There are three solutions to this problem. Episode 536 compares them all. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download(…)

Learn Excel from MrExcel