Puneet Gogia

100+ Codes100 Excel VBA Codes – Macro LibraryLast Updated: 27th April 2026 by Puneet Gogia Jump to a Category Cells & Ranges10 codes Formatting & Highlighting20 codes Text & String

This Tutorial is Written by Puneet Gogia (Microsoft Excel MVP) was last updated on 01-Feb-2026 In Excel, when you have data, most of the time you don’t have serial numbers

And after that, I told him about five different methods for this but then he got confused about which method is easy. Even I have created a small UDF to make it super easy for him to remove n number of characters from the start of a string.