Quick question, hopefully simple question, from a confused newbie.
I have 1,000 block of digits, each block is separated by 3 carriage returns in Notepad.
I want to copy and paste into Excel and auto number each block - see sample below
I want to number each block i.e. Block 1, Block 2...