Splitting Net Names

If you are using Excel 2007 or higher you can use the 'Text to Column' command to split Net names or other delimited text.

Shown below is an example which splitting the text in column A into 3 columns.

Click on images to view.

Why split ? To sort, then concatenate.