Excel 2000: Quick Concatenation Question 1

[goopit]

Good Day All,

I'm having trouble writing a concatenation so that when I grab the text from the cell I want it will look like this:
"AMAZING GOOP",. I want to add quote marks before and after the text and finish it off with a comma at the end.

Any and all help will be much appreciated.

Thanks,

Scott

 

[AnotherHiggins]

If Amazing Goop is in cell A1, then
=""""&A1&""","

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[goopit]

Brilliant!

Thank you very much for your help, John. Have a star.

Scott

 

[AnotherHiggins]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.