Betsy wants to add @auburn.edu to the end of serveral thousand user names. I searched Excel help (user names are in an Excel file) and found concatenate. This is a pretty cool function. To concatenate the contents of two or more cells (or text) would look something like this:
=contatenate(A1,"@auburn.edu"). The user name contents of cell A1 would then be concatenated to @auburn.edu in the cell where the function appears. The function could easily be copied down the page. Try it, you'll like it!
No comments:
Post a Comment