| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula help
Hi, I am trying to search for inverted commas in a text string using the
search formula, I tried to put the inverted comma within inverted commas but that did not work i.e. =SEARCH(""",B2,1) ....thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula help
Do you mean you're looking for double quotes " ?
A1 = look "for" this =FIND("""",A2) That's 4 double quotes " " " " -- Biff Microsoft Excel MVP "Simon S" wrote in message ... Hi, I am trying to search for inverted commas in a text string using the search formula, I tried to put the inverted comma within inverted commas but that did not work i.e. =SEARCH(""",B2,1) ....thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula help
=SEARCH("""",B2,1)
OR =SEARCH(CHAR(34),B2) If this post helps click Yes --------------- Jacob Skaria "Simon S" wrote: Hi, I am trying to search for inverted commas in a text string using the search formula, I tried to put the inverted comma within inverted commas but that did not work i.e. =SEARCH(""",B2,1) ....thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula help
it worked thanks =SEARCH(CHAR(34),B2)
"Jacob Skaria" wrote: =SEARCH("""",B2,1) OR =SEARCH(CHAR(34),B2) If this post helps click Yes --------------- Jacob Skaria "Simon S" wrote: Hi, I am trying to search for inverted commas in a text string using the search formula, I tried to put the inverted comma within inverted commas but that did not work i.e. =SEARCH(""",B2,1) ....thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula help
No just searhing for one lot, Jacobs answer worked, thanks anyway
"T. Valko" wrote: Do you mean you're looking for double quotes " ? A1 = look "for" this =FIND("""",A2) That's 4 double quotes " " " " -- Biff Microsoft Excel MVP "Simon S" wrote in message ... Hi, I am trying to search for inverted commas in a text string using the search formula, I tried to put the inverted comma within inverted commas but that did not work i.e. =SEARCH(""",B2,1) ....thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula help
No just one lot, Jacobs CHAR34 worked, thanks anyway
"T. Valko" wrote: Do you mean you're looking for double quotes " ? A1 = look "for" this =FIND("""",A2) That's 4 double quotes " " " " -- Biff Microsoft Excel MVP "Simon S" wrote in message ... Hi, I am trying to search for inverted commas in a text string using the search formula, I tried to put the inverted comma within inverted commas but that did not work i.e. =SEARCH(""",B2,1) ....thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula help
Ooops!
A1 = look "for" this =FIND("""",A2) Should be: =FIND("""",A1) I've had a lot of ooopses the last couple of days! -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Do you mean you're looking for double quotes " ? A1 = look "for" this =FIND("""",A2) That's 4 double quotes " " " " -- Biff Microsoft Excel MVP "Simon S" wrote in message ... Hi, I am trying to search for inverted commas in a text string using the search formula, I tried to put the inverted comma within inverted commas but that did not work i.e. =SEARCH(""",B2,1) ....thanks |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula help
No just one lot, Jacobs CHAR34 worked, thanks anyway
"T. Valko" wrote: Do you mean you're looking for double quotes " ? A1 = look "for" this =FIND("""",A2) That's 4 double quotes " " " " -- Biff Microsoft Excel MVP "Simon S" wrote in message ... Hi, I am trying to search for inverted commas in a text string using the search formula, I tried to put the inverted comma within inverted commas but that did not work i.e. =SEARCH(""",B2,1) ....thanks |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula help
I'm not saying that Jacob's solution doesn't work, but so does Valko's
=FIND("""",A1) or =FIND(CHAR(34),A1) both work and are shorter then SEARCH. As was stated this is four double-quotes in a row! -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Simon S" wrote: it worked thanks =SEARCH(CHAR(34),B2) "Jacob Skaria" wrote: =SEARCH("""",B2,1) OR =SEARCH(CHAR(34),B2) If this post helps click Yes --------------- Jacob Skaria "Simon S" wrote: Hi, I am trying to search for inverted commas in a text string using the search formula, I tried to put the inverted comma within inverted commas but that did not work i.e. =SEARCH(""",B2,1) ....thanks |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula help
I'll have to remember CHAR(34). That seems less cryptic.
-- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... =SEARCH("""",B2,1) OR =SEARCH(CHAR(34),B2) If this post helps click Yes --------------- Jacob Skaria "Simon S" wrote: Hi, I am trying to search for inverted commas in a text string using the search formula, I tried to put the inverted comma within inverted commas but that did not work i.e. =SEARCH(""",B2,1) ....thanks |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula help
I'm pretty sure my suggestion works. If it didn't work for you you'd have
give me more detail as to what *exactly* you're trying to do. -- Biff Microsoft Excel MVP "Simon S" wrote in message ... No just one lot, Jacobs CHAR34 worked, thanks anyway "T. Valko" wrote: Do you mean you're looking for double quotes " ? A1 = look "for" this =FIND("""",A2) That's 4 double quotes " " " " -- Biff Microsoft Excel MVP "Simon S" wrote in message ... Hi, I am trying to search for inverted commas in a text string using the search formula, I tried to put the inverted comma within inverted commas but that did not work i.e. =SEARCH(""",B2,1) ....thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
![Simon S[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
