I have a data in a txt file as follow. How do I extract them into excel column?
Please Login or Register to view this content.
I have a data in a txt file as follow. How do I extract them into excel column?
Please Login or Register to view this content.
Please reply and attach your text file
- click Reply
- click Go Advanced
- look below for Manage Attachments
- folllow screen instructions
thanks
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Here's the txt file. Thank you.
deleted by Kev-
jindon provided solution before I amended my code
Last edited by kev_; 09-13-2017 at 06:52 AM.
Try
or perhapsPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by jindon; 09-13-2017 at 07:08 AM.
For the first one I get this result.
For the second one I get this. Only the Value column is missing. Probably because when it follows by number there is no quotation marks?Please Login or Register to view this content.
This is the one I want. Thank you.
Please Login or Register to view this content.
Last edited by hellowit; 09-13-2017 at 09:45 PM.
Change to
Please Login or Register to view this content.
It works perfectly. Thank you so much.
Out of curiosity, if I want the result to be in an array instead of cells. Is there anyway to do that?
Variable a is a 2d array.
Please Login or Register to view this content.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks