Hi all, I am new to VBA functions. I have a requirement to extract substring from a delimited file, and could do correctly using excel formula, though it ended up in long complicated ones! Now I am looking to consolidate all into one button. I tried VBA but some functions when converted to VBA are not working.(Eg . SUBSTITUTE). Is there a way I can use the exact Excel Formula in a VB / or any other way? Should I use Command Button ? Regards,