Hi All,
Can anyone help me on this problem?
I have 100k++ data which is in text file. But I need to separate them and formula is not doing any good as the number lengths are not the same.
the key identifier is the | that separates the number.
Hope someone can help me.
sample:
Hi geliedee,
On the Data Tab there is an Icon called "Text to Columns" that was meant for this type of problem Select column A, click on Data > Text to Columns and make the character to split by a "|". Problem done.
https://www.excel-easy.com/examples/...o-columns.html
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
How are you opening the file?
[Data] - [Text file] and follow the instruction for importing.
Should do easily and you can also manage the data types etc.
Re: macro to split data in text file
Originally Posted by geliedee
Hi !
Attach at least a source text file sample or use the easy Text Import Wizard (Data, Import from file) …
Easy VBA way via Workbooks.Open method (like OpenText as well), just reading the VBA help.
Last edited by Marc L; 03-23-2020 at 11:55 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks