Excel 2003 - how to add text as a prefix to another cell?

[InflatableBuddha]

I have two columns - one with an alias, the other with the name of a webpage. The webpage names are incorrect.

I need a formula to search for a prefix in the alias column, then change the names of the webpages in the corresponding cell in the adjacent column so that they add a prefix to make them correct.

For example, the current list looks like this:

howto_sample | sample.html
master_test | test.html
...

Should be:

howto_sample | howto_sample.html
master_test | master_test.html
...

There are 3 prefixes (howto_, master_, w_) so I will repeat the formula 3 times, each time with a different prefix. What is the best way to accomplish this?

Thanks.

 

[Ken g6]

Given your columns, and the procedure your specified, C1:

=LEFT(A1,FIND("_",A1))&B1

If the part after "_" is the same as the beginning of the second column, though, couldn't you just do B1:

=A1&".html"

?

 

[InflatableBuddha]

Your second solution worked perfectly, and I just copied the formula down the column. Thanks!