I am in a lock down environment. Need to extract some information for the text file and save it to excel in table form.
see below text file sample.
basically i need to extract name, email and telephone number and tabulate to excel.
how can i do this using excel vba macro? appreciate if someone can shed a light.
View attachment info.txt
see below text file sample.
basically i need to extract name, email and telephone number and tabulate to excel.
how can i do this using excel vba macro? appreciate if someone can shed a light.
View attachment info.txt