Macro to replace a particular word in each line

[freeda910]

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

 

[freeda910]

Hi,
I dont know if this is possible or not but thought I'd ask anyway.
Any help would be GREATLY appreciated.

 

[freeda910]

Its an urgent work.
i have more than 2800 students names to be updated.
was their anyone to help me.