Split Full Names, Parse Codes, Join Columns — Text Manipulation with LEFT, MID, FIND, SUBSTITUTE and TEXTJOIN in C#
Splitting full names into first and last, pulling the domain out of an email address, breaking a product code apart at the hyphens — string cleanup is one line of C# with Split, but if users need to see and fix the results on screen, spreadsheet formulas are the better tool. This guide covers the workhorse recipes built from LEFT, MID, FIND, SUBSTITUTE, and TEXTJOIN, the classic traps (stray spaces, the missing SEARCH function), and how ReoGrid (supported in V4.5) runs the same formulas inside a WinForms / WPF app — no Office required.
