Macro to replace a particular word in each line

freeda910

New Member
Joined
Feb 8, 2014
Messages
18
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
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

freeda910

New Member
Joined
Feb 8, 2014
Messages
18
Hi,
I dont know if this is possible or not but thought I'd ask anyway.
Any help would be GREATLY appreciated.
 

freeda910

New Member
Joined
Feb 8, 2014
Messages
18
Its an urgent work.
i have more than 2800 students names to be updated.
was their anyone to help me.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,001
Messages
5,526,196
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top