We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

how to get quotes around text in excel

onyourmark
onyourmark asked
on
Medium Priority
314 Views
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.
FukuokaNewsRearranged4.csv
Comment
Watch Question

Top Expert 2011

Commented:
Add an apostrophe to the beginning of a cell and then you'll find that you can include quotes in the cells without issue.
Top Expert 2011

Commented:

Author

Commented:
Thanks for the reply. How do I add an apostrophe just to the entries in columns 3, 4, 5, and 6?
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)
Top Expert 2011
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Engineer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks all. It works!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.