Newbie: Need macro that concatenates two strings on each line

[gotsowell]

I am not familiar with how to use Excel VBA or macros. Is it a macro I need? If so, how do I set it up?

I'm concatenating strings in two cells per row and need to do the same for 100-200 rows at a time.

=CONCATENATE(A1, "/",B1) gives correct output once. How do I implement concatenating a range?

EXAMPLE
A B
1 http://sos.oregon.gov/business Pages/default.aspx EXPECTED OUTPUT >> http://sos.oregon.gov/business/Pages/default.aspx
2 http://sos.oregon.gov/business Pages/apostille.aspx
3 http://sos.oregon.gov/business Pages/articles-of-incorporation-information.aspx

Thx!

[pjwhitfield]

Double click the bottom right corner of the cell containing the formula, this will reproduce the formula in every cell of the existing rows.

[gotsowell]

That's really slick. Thanks!