Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore Symbols in a formula?
(Hopefully my last question today.)
so i have a formula similiar to below. I need to have ( ) in the sentence as well as other possible symbols, that I dont want as part of the formula. How do I exclude? [A1] = "I want to purchase " &C2& " candy bars (Blue ones) from the grocery store" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore Symbols in a formula?
dj,
Since the parentheses are in a text string, they'll just appear like any other text. Your formula should work. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "dj479794" wrote in message ... (Hopefully my last question today.) so i have a formula similiar to below. I need to have ( ) in the sentence as well as other possible symbols, that I dont want as part of the formula. How do I exclude? [A1] = "I want to purchase " &C2& " candy bars (Blue ones) from the grocery store" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore Symbols in a formula?
Earl,
Hhhhmmm. Maybe it is that I have "quotation marks" in my setence as well. Maybe those need to be excluded? I also have brackets [ ]. Sounds weird, but is it a legal statement and you know how lawyers are about having the exact statement. "Earl Kiosterud" wrote: dj, Since the parentheses are in a text string, they'll just appear like any other text. Your formula should work. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "dj479794" wrote in message ... (Hopefully my last question today.) so i have a formula similiar to below. I need to have ( ) in the sentence as well as other possible symbols, that I dont want as part of the formula. How do I exclude? [A1] = "I want to purchase " &C2& " candy bars (Blue ones) from the grocery store" |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore Symbols in a formula?
The parenthesis and brackets, when placed inside of quotation marks, will not
have any ill effects on your formula. They will be treated as part of the text string. However, if you want to include double-quotes in your text string, you'll need to do 2 of them. For example: ="This sentence contains ""quotes""" Note that the use of 2 consecutive double-quotes tells excel to treat them as a single symbol rather than an indicator of the beginning or end of a text string. HTH, Elkar "dj479794" wrote: Earl, Hhhhmmm. Maybe it is that I have "quotation marks" in my setence as well. Maybe those need to be excluded? I also have brackets [ ]. Sounds weird, but is it a legal statement and you know how lawyers are about having the exact statement. "Earl Kiosterud" wrote: dj, Since the parentheses are in a text string, they'll just appear like any other text. Your formula should work. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "dj479794" wrote in message ... (Hopefully my last question today.) so i have a formula similiar to below. I need to have ( ) in the sentence as well as other possible symbols, that I dont want as part of the formula. How do I exclude? [A1] = "I want to purchase " &C2& " candy bars (Blue ones) from the grocery store" |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore Symbols in a formula?
Thanks! Got it to work. Side question if I have the same text string formula.
and I insert a number. How do I get the number to be formated with the comma for "thousands" = "I want to purchase " &C2& " candy bars (Blue ones) from the grocery store" "Elkar" wrote: "I want to purchase " 10,000 " candy bars (Blue ones) from the grocery store" I tried TEXT(A1,#,###) and doesnt work Also, I want to put only a couple of words in bold font?. The parenthesis and brackets, when placed inside of quotation marks, will not have any ill effects on your formula. They will be treated as part of the text string. However, if you want to include double-quotes in your text string, you'll need to do 2 of them. For example: ="This sentence contains ""quotes""" Note that the use of 2 consecutive double-quotes tells excel to treat them as a single symbol rather than an indicator of the beginning or end of a text string. HTH, Elkar "dj479794" wrote: Earl, Hhhhmmm. Maybe it is that I have "quotation marks" in my setence as well. Maybe those need to be excluded? I also have brackets [ ]. Sounds weird, but is it a legal statement and you know how lawyers are about having the exact statement. "Earl Kiosterud" wrote: dj, Since the parentheses are in a text string, they'll just appear like any other text. Your formula should work. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "dj479794" wrote in message ... (Hopefully my last question today.) so i have a formula similiar to below. I need to have ( ) in the sentence as well as other possible symbols, that I dont want as part of the formula. How do I exclude? [A1] = "I want to purchase " &C2& " candy bars (Blue ones) from the grocery store" |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore Symbols in a formula?
Use the TEXT function. Like this:
"I want to purchase " &TEXT(C2,"#,##0")& " candy bars (Blue ones) from the grocery store" HTH, Elkar "dj479794" wrote: Thanks! Got it to work. Side question if I have the same text string formula. and I insert a number. How do I get the number to be formated with the comma for "thousands" = "I want to purchase " &C2& " candy bars (Blue ones) from the grocery store" "Elkar" wrote: "I want to purchase " 10,000 " candy bars (Blue ones) from the grocery store" I tried TEXT(A1,#,###) and doesnt work Also, I want to put only a couple of words in bold font?. The parenthesis and brackets, when placed inside of quotation marks, will not have any ill effects on your formula. They will be treated as part of the text string. However, if you want to include double-quotes in your text string, you'll need to do 2 of them. For example: ="This sentence contains ""quotes""" Note that the use of 2 consecutive double-quotes tells excel to treat them as a single symbol rather than an indicator of the beginning or end of a text string. HTH, Elkar "dj479794" wrote: Earl, Hhhhmmm. Maybe it is that I have "quotation marks" in my setence as well. Maybe those need to be excluded? I also have brackets [ ]. Sounds weird, but is it a legal statement and you know how lawyers are about having the exact statement. "Earl Kiosterud" wrote: dj, Since the parentheses are in a text string, they'll just appear like any other text. Your formula should work. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "dj479794" wrote in message ... (Hopefully my last question today.) so i have a formula similiar to below. I need to have ( ) in the sentence as well as other possible symbols, that I dont want as part of the formula. How do I exclude? [A1] = "I want to purchase " &C2& " candy bars (Blue ones) from the grocery store" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore #N/A in a formula | Excel Discussion (Misc queries) | |||
Is there a list of what certain symbols mean in a formula? | Excel Discussion (Misc queries) | |||
what do the { } symbols indicate when surrounding a formula? | Excel Discussion (Misc queries) | |||
How can I ignore an #N/A value in a =SUM() formula? | Excel Worksheet Functions | |||
Ignore Symbols in a cell | Excel Discussion (Misc queries) |