Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


how to get quotes around text in excel

Posted on 2011-04-19
Medium Priority
Last Modified: 2012-05-11
Hi. I have a file that has text fields (Username      Text      Location      Followings) and I want to get quotes around all these the entries in each of these columns. Is there an easy way to do that? The file is attached.

Thank you.
Question by:onyourmark
LVL 23

Expert Comment

by:Brian Gee
ID: 35430666
Add an apostrophe to the beginning of a cell and then you'll find that you can include quotes in the cells without issue.
LVL 23

Expert Comment

by:Brian Gee
ID: 35430672

Author Comment

ID: 35430725
Thanks for the reply. How do I add an apostrophe just to the entries in columns 3, 4, 5, and 6?
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Expert Comment

ID: 35430773
try this in the cells under "Username".
Include entire string along with "equal" sign

=CHAR(34) & "http://mlb.mlb.com/news/article.jsp?ymd=20110103&content_id=16383306&c_id=mlb" & CHAR(34)
LVL 23

Assisted Solution

by:Brian Gee
Brian Gee earned 800 total points
ID: 35430794
Creating a column D (moving the existing column D to E) and then using the below can get you output for the entire column pretty easily... if you want to go the VBA, that's is an option as well.

LVL 43

Accepted Solution

Saqib Husain, Syed earned 1200 total points
ID: 35430795
Enter this formula in cell I2


and copy it down and across

You will get all the text quoted as results of formulas

Copy these and paste-special as values back to C2...


Author Closing Comment

ID: 35430810
Thanks all. It works!

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question