excel hell

I'll try to explain the basics of Excel in short terms. As I don't know your layout, you will have to modify the cell references to match your file: (Note: Save your file before you begin...just in case!!)

If your names are in Columns A and B, in column C enter this formula next to the name at the top of your list: (if column C already has data in it, you will need to insert a column--type "Insert Column" in HELP to find out how)

=B1&", "&A1 <<NOTE: this formula assumes you are in row 1, change the 1 if needed to match the actual row your data is in>>

Type the above formula exactly as it appears, there is a space after the comma.

Press the Enter key and you should now see "Lastname, Firstname" in your cell
(no quotes)

Click in this cell to select it, you will see the dark box that outlines this cell, notice it has a small black box in the lower righthand corner.

Move your cursor over top of this box and the cursor changes to a small cross. Click and hold down the mouse button and "drag" down (notice that a rectangle is drawn to show the range you are covering). When you reach the end of your data, release your mouse button. Your formula is now copied into all the cells in this column. Each cell should now display the names joined as described above.

Good Luck

Bruce, it worked thank you, i do at least know inserting and dragging and once i even waterski'd! but this had me perplexed! THANK YOU SOOOO MUCH!

Glad it worked for you. Hmmm, I've never water ski'd! I'm impressed!

Thanks for the feedback.