Manipulating the Sakai Data WITHOUT using a VBA Macro.
Remove the return but keep the space in Excel
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(…)
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(…)