I want to import the content of a text file into excel and filter the rows which has equal sign through VBA code, can anyone help
txt file will be of below format
<code>Fruits
x=apple
Toys
y=ball
Communication
z=phone
</code>
<code>Fruits
x=apple
Toys
y=ball
Communication
z=phone
</code>
Fruits
x=apple
Toys
y=ball
Communication
z=phone
Output in the excel file to be
<code>x apple
y ball
z phone
</code>
<code>x apple
y ball
z phone
</code>
x apple
y ball
z phone
New contributor
Anthony is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.