add a character to every cell

Hello everyone! I have a question that will hopefully be simple.

i have an excel page with one column and around 2000 rows. The problem is, I need to add an @ symbol at the beginning of each cell. Is there a function that will help me achieve this easily? typing them all by hand would be insane.


Thanks!


pikaz

What if the symbol you wanat to add " is the quotation mark ?
="""&A1&""" does not work
Is there another formula that will work for this?

Originally Posted by harrywaldron

P.S. This question was good, as it helped me in some of my daily tasks find a better way

I often have to lookup information in Toad, which is an Oracle SQL browser. In the past, I'd copy these cells to notepad and manually add quotes in front and back, plus a comma at the end. If there were 00's of entries, I'd put a quote in column A and quote/comma in C and concatenate cells A/B/C.

Using the formula below, I discovered a way to put quotes and commas around a excel for Toad automatically for a whole column of items.

How to put quotes in front of and at the end of cell B1 with a comma on the end

="'"&B1&"',"

Hey Guys
This post made my life so much easier and saved me so much I that I had to take the time to say thank-you.

I am converting product codes over to bar codes and I need to put an * in front and back of the code for it to work so I used this post to make life easier.
="*"&A1&"*"
Sure is a lot easier than going through each cell and adding to it.
Again, Thanks
Tom

I don't see much point in responding to a thread which is eight years old.

Pete