I would do this in Word to avoid the issue of Excel spilling over.
You didn't give us much of a view of your dataset but assuming each record actually starts with "/" then it would be simple to do a search and replace series and then to convert it all to a table.
Find "^p" and replace with "zxzx"
Find "zxzx/" and replace with "^p/"
Find ",,,," and replace with "^t"
Now convert to table with tab delimiters.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Last edited by Guessed; 03-17-2015 at 05:13 PM.
Reason: Forgot to include the / in the second replace (as spotted by BruceM)
|