excel, add ' ' to the text

Hi Experts,

In my column showing text

If I want to add  '  '  to them , like this

How do I do it ? Thanks?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamMicrosoft Excel ExpertCommented:

Copy down the formula
ProfessorJimJamMicrosoft Excel ExpertCommented:
Assuming that your data is in column A and start from second row. Use the above formula or

Copy down
tanj1035Author Commented:
Thanks, but
 it returned 0.
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

ProfessorJimJamMicrosoft Excel ExpertCommented:
Where is your range of data?
ProfessorJimJamMicrosoft Excel ExpertCommented:
It returned zero perhaps because there mohht be no data in A2
ProfessorJimJamMicrosoft Excel ExpertCommented:
What are the cell format is it text or number?
Saurabh Singh TeotiaCommented:
Can you try using...


tanj1035Author Commented:
I tried the second one as well. It still returned 0. There is data in A2.
Saurabh Singh TeotiaCommented:
you need to apply this formula in b2..rather then a2..the reason its returning zero because you are creating a cyclic formula as in referring the same cell in the formula where you are applying the formula..

so what i mean if A2=A then apply this formula in B2="'"&trim(a2)&"'"
tanj1035Author Commented:
="'"&trim(a1)&"'" worked to a new column, but not the original column. How can I do it on the original column ?Thx.
Saurabh Singh TeotiaCommented:
Once it works on a new column-->Copy the data and then go back to your original column and right click-->paste special-->values

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ProfessorJimJamMicrosoft Excel ExpertCommented:
=CONCATENATE("'",A2,"'")  Worked for me
Saurabh Singh TeotiaCommented:
Alternatively if you just want the visual display and don't won't quotes their you can press ctrl+1 on the cell then custom and apply this formatting-->'@'

This will show visual display of values have single quotes but the actual value remains without quotes..
Martin LissOlder than dirtCommented:
In a macro

Range(A1").Formula = "''" & Range("A1").Formula & "'"
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.