I often create reports on various system objects whith use of IDs. Can somone help me understand on how should I get my IDs exported and fomated so I can copy and paste it to text mode? As far as I know I can never get the spaces right.
It will be difficult to show this with snapshots.
For excample, today I filtered a set of template tasks by which I wanted to identify parallel project tasks. I had approx 200 ids but am unable to correctly trasnposte these from excel export to taxt mode filter. I seem unable to replicate the space between individual IDs in any format: text, excel etc. I am preatty sure it must be format issue but I cant find a way to automate it. I simply want to avoid entering these IDs manually.
I usually export to Excel, copy the column I want, paste that into Word without formatting (so it comes in as lines instead of a table), bulk replace the paragraph breaks with tabs, and remove the tab at the very end of the sentence. That's just me, though.