Hi,

Thanks Tony. I couldn't do array-enter in my spreadsheet. But I got the logic behind it. Can I get the same in VBA where i can enter different no of characters ( 4 or 6 or 11 or etc.,) in cell E1 as attached?

Thanks
John