hi mike
thanks for that
i got them into excel
how do i separate them into two columns?
it only lets me paste as unicode
sorry i'm new to this
thanks
ron
OK, go to CMP and copy the selection to the clipboard (Ctrl-C will do it)
Open Excel at a blank workbook.
Select the top-left cell
Ctrl-V to past the text.
Don't select any other cells, just leave it selected as it is, then select 'Data' -> 'Text to Columns' from the top menu bar.
Step one of the process lets you choose between 'delimited' or 'fixed width', we want 'delimited' (should be the default option)
Click 'Next'
In the 'Delimiters' section un-tick 'Tab' and click 'Comma'
Then click 'Next'
Step 3 lets you change cell formats, we don't need to change anything so just click 'Finish'
You should now have one column with names, and a second column with their KUIDs.
Mike.
(The above was in Excel 2003, other versions should be roughly the same)
EDIT: if you try this with the TRS2006 CMP it isn't comma-delimited so when you paste the listing you just need to change the column widths.