Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enclose text in a cell in quotes
If I have some text in a cell and I want to wrap that text in quotes, do you
know of a simple way to do that i.e Cell says Whoever answers this question is the greatest and I want it to be €śWhoever answers this question is the greatest€ť And I want to do that for everything in that particular column? Thanks |
#2
|
|||
|
|||
Answer: How to enclose text in a cell in quotes
There is a simple way to enclose text in a cell in Microsoft Excel. Here are the steps:
Now, all the text in the selected column will be enclosed in quotes. If you want to apply this format to a specific cell, you can simply select that cell and follow the same steps.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enclose text in a cell in quotes
You could, of course, use a helper column to get your results. For example,
if your data begins in cell A1, then use this formula in another column and copy down as needed. ="""" & A1 & """" HTH, Paul -- "booker@mgt" wrote in message ... If I have some text in a cell and I want to wrap that text in quotes, do you know of a simple way to do that i.e Cell says Whoever answers this question is the greatest and I want it to be "Whoever answers this question is the greatest" And I want to do that for everything in that particular column? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enclose text in a cell in quotes
You could insert a helper column to the right and use a formula like:
=char(34) & a1 & char(34) or =""""&A1&"""" Drag down as far as you need. Then copy this column and paste special|values over the original column. Then delete the helper column. booker@mgt wrote: If I have some text in a cell and I want to wrap that text in quotes, do you know of a simple way to do that i.e Cell says Whoever answers this question is the greatest and I want it to be €śWhoever answers this question is the greatest€ť And I want to do that for everything in that particular column? Thanks -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enclose text in a cell in quotes
Should do it. Change f to suit your column. Send Wild Turkey 101.
Sub makequotes() mc = "f" For i = 2 To Cells(Rows.Count, mc).End(xlUp).Row If Cells(i, mc) < "" And Left(Cells(i, mc), 1) < """" Then Cells(i, mc).Value = """" & Cells(i, mc) & """" End If Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "booker@mgt" wrote in message ... If I have some text in a cell and I want to wrap that text in quotes, do you know of a simple way to do that i.e Cell says Whoever answers this question is the greatest and I want it to be €śWhoever answers this question is the greatest€ť And I want to do that for everything in that particular column? Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enclose text in a cell in quotes
Thanks
"PCLIVE" wrote: You could, of course, use a helper column to get your results. For example, if your data begins in cell A1, then use this formula in another column and copy down as needed. ="""" & A1 & """" HTH, Paul -- "booker@mgt" wrote in message ... If I have some text in a cell and I want to wrap that text in quotes, do you know of a simple way to do that i.e Cell says Whoever answers this question is the greatest and I want it to be "Whoever answers this question is the greatest" And I want to do that for everything in that particular column? Thanks |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enclose text in a cell in quotes
Thanks Don, I ended up using the suggesstion above you, but I did document
your solution as well. Thanks "Don Guillett" wrote: Should do it. Change f to suit your column. Send Wild Turkey 101. Sub makequotes() mc = "f" For i = 2 To Cells(Rows.Count, mc).End(xlUp).Row If Cells(i, mc) < "" And Left(Cells(i, mc), 1) < """" Then Cells(i, mc).Value = """" & Cells(i, mc) & """" End If Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "booker@mgt" wrote in message ... If I have some text in a cell and I want to wrap that text in quotes, do you know of a simple way to do that i.e Cell says Whoever answers this question is the greatest and I want it to be €śWhoever answers this question is the greatest€ť And I want to do that for everything in that particular column? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enclose all data values in a column in double quotes? | Excel Worksheet Functions | |||
Need quotes around exported tab delimited text | Excel Discussion (Misc queries) | |||
saving an excel file as text without text in quotes | Excel Discussion (Misc queries) | |||
How do I get stock quotes in Excel without text? | Excel Worksheet Functions | |||
why are there quotes in my exported text file? | Excel Discussion (Misc queries) |