I was given a text file that needed to be ran through excel for a word count pivot table. The txt file I received was un-formatted and only spaces were the common search I could do.
In Notepad++ I searched for \s and replaced it with \n to produce a line per word. This allowed me to import into excel for further analysis.
Post a Comment