Hi All,
Was wondering if someone could tell me how to solve this problem.
I am having a set of students name in an excel file.
ALEX,BOB,CIMON,DEN..... (FROM A1 TO A20)
This is the sample website name
http://www.stnd.com/username/webid/webid.jsp?Name=AAA&add=CM&sus.jsp
FROM B1 TO B20 this particular AAA has to be replaced with students name.
REQUIRED RESULT IN B1 TO B20
http://www.stnd.com/username/webid/webid.jsp?Name=ALEX&add=CM&sus.jsp
http://www.stnd.com/username/webid/webid.jsp?Name=BOB&add=CM&sus.jsp
http://www.stnd.com/username/webid/webid.jsp?Name=CIMON&add=CM&sus.jsp
http://www.stnd.com/username/webid/webid.jsp?Name=DEN&add=CM&sus.jsp
.
..........
Please help.
thanks,
Freeda
Was wondering if someone could tell me how to solve this problem.
I am having a set of students name in an excel file.
ALEX,BOB,CIMON,DEN..... (FROM A1 TO A20)
This is the sample website name
http://www.stnd.com/username/webid/webid.jsp?Name=AAA&add=CM&sus.jsp
FROM B1 TO B20 this particular AAA has to be replaced with students name.
REQUIRED RESULT IN B1 TO B20
http://www.stnd.com/username/webid/webid.jsp?Name=ALEX&add=CM&sus.jsp
http://www.stnd.com/username/webid/webid.jsp?Name=BOB&add=CM&sus.jsp
http://www.stnd.com/username/webid/webid.jsp?Name=CIMON&add=CM&sus.jsp
http://www.stnd.com/username/webid/webid.jsp?Name=DEN&add=CM&sus.jsp
.
..........
Please help.
thanks,
Freeda