Using VBA , get notepad and copy specific text in a specific column one by one
I have been looking for a way to code in VBA: I have list of addresses like below, move to: Sam Santhosh No : 13a,1st street, vadapalani Chennai-26 Mob no: 9999999999 mail: firstname.lastname@example.org
move to: Samma Ravi No : 56,1st street, mogappair Chennai-26 Mob no: 2222222222 mail: email@example.com
i would like to place "move to:" value to column1,Name value to Column2,Address value to Column3, "Mob no" value to Column4, "Mail id" value to Column 5 for all list of addresses.I have placed output for reference below.I am struggling to make like this.Can you please help me on this. Thanks for your help!
move to Name Address Mob no mail
Sam Santhosh No : 13a,1st street, vadapalani Chennai-26 9999999999 firstname.lastname@example.org
Samma Ravi No : 56,1st street, mogappair Chennai-26 2222222222 email@example.com