Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating text surrounded by quotation marks
I am looking for a way to make a text string to appear in quotation marks.
For example, if someone types in the text string Titanic in cell A1 I need to be able to generate in cell B1 the exact text "Titanic" (with the quotes visible around whatever is types in cell A1) I can't figure it out. The use of quotation marks in formulae is compounding the problem. Has anyone else ever solved this mystery. Jeff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating text surrounded by quotation marks
In B1 ="''" & A1 & "''"
that is a quote " then two ' then quote " at the beginning and end -- -John Please rate when your question is answered to help us and others know what is helpful. "AaronQRules (a.k.a. Jeff)" wrote: I am looking for a way to make a text string to appear in quotation marks. For example, if someone types in the text string Titanic in cell A1 I need to be able to generate in cell B1 the exact text "Titanic" (with the quotes visible around whatever is types in cell A1) I can't figure it out. The use of quotation marks in formulae is compounding the problem. Has anyone else ever solved this mystery. Jeff |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating text surrounded by quotation marks
Try:
="""" & A1 &"""" 4 double quotes (") "AaronQRules (a.k.a. Jeff)" wrote: I am looking for a way to make a text string to appear in quotation marks. For example, if someone types in the text string Titanic in cell A1 I need to be able to generate in cell B1 the exact text "Titanic" (with the quotes visible around whatever is types in cell A1) I can't figure it out. The use of quotation marks in formulae is compounding the problem. Has anyone else ever solved this mystery. Jeff |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating text surrounded by quotation marks
Wait 'til you see all these quotes! <BG
Try it like this: =IF(A1="","",""""&A1&"""") That's 4 double quotes on either side of &A1& -- Biff Microsoft Excel MVP "AaronQRules (a.k.a. Jeff)" <AaronQRules (a.k.a. wrote in message ... I am looking for a way to make a text string to appear in quotation marks. For example, if someone types in the text string Titanic in cell A1 I need to be able to generate in cell B1 the exact text "Titanic" (with the quotes visible around whatever is types in cell A1) I can't figure it out. The use of quotation marks in formulae is compounding the problem. Has anyone else ever solved this mystery. Jeff |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating text surrounded by quotation marks
=""""&A1&""""
[4 sets of quotes at a time.] -- David Biddulph "AaronQRules (a.k.a. Jeff)" <AaronQRules (a.k.a. wrote in message ... I am looking for a way to make a text string to appear in quotation marks. For example, if someone types in the text string Titanic in cell A1 I need to be able to generate in cell B1 the exact text "Titanic" (with the quotes visible around whatever is types in cell A1) I can't figure it out. The use of quotation marks in formulae is compounding the problem. Has anyone else ever solved this mystery. Jeff |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating text surrounded by quotation marks
Thanks to all for the help! This works for me for my project!
Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quotation Marks | Excel Discussion (Misc queries) | |||
Quotation Marks? | Excel Worksheet Functions | |||
Quotation Marks - When and What?? | Excel Discussion (Misc queries) | |||
After exporting how do I remove quotation marks from text cells | Excel Discussion (Misc queries) | |||
How do I concatenate text that actually contains quotation marks? | Excel Worksheet Functions |