cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2220
Views
0
Helpful
1
Replies
Highlighted
Beginner

How to create port descriptions from excel spreadsheet

Our cabling contractor gives us a spreadsheet of room# and patch panel# in spreadsheet format. Working for a University we are always having new buildings pop up with many ports. In this case, we have 25 buildings with 1, 48 port switch in each. I received the spreadsheet and am looking for a way to grab the info off the spreadsheet to be able to turn into an automated script or something that will create a way to speed up the process of naming all these ports.

The ideal thing I would like to do is have something just do

int fa0/1

desc xxxxxx

int fa0/2

desc xxxxx

and so on.

Does anyone have any special tools/tricks they use when it comes to multiple port naming.

This is how the spreadsheet looks...

House# 121
  Room#Port#
1018
1017
10416
10610
10311
1 REPLY 1
Highlighted
Beginner

In the past I have used the concatenate function in Excel.I always use the inset fuction to help create the statement.

Content for Community-Ad