Automatically Inserting Comments

[joshmv]

I have this small task that is driving me crazy because it's so simple but I can't seem to work it out.

All I'm going to do is copy a big list of words, and then paste them into a column.

At that point, I just need to put an apostrophe before each word, and then an apostrophe and comma right after the word in the same column.

I'm pretty sure I can accomplish that in Excel, but it's been a while since I've done any formula's.

Thanks!

Josh

[mrchoppychops]

where your list starts in A1 in B1 enter

=CONCATENATE("'",A1,"',")

and drag this down the length of your list.