Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How to select quotation marks within quotation marks?
Need to select data enclosed within quotation marks. Tried using the \ (backslash) method as used in formatting but to no avail.
Example being A1 contains IF(A2=VALUE("1"),etc and I want to select the text "1" to use in SUBSTITUTE(A1,""1"","~") it generates an error if using double quotation marks. Excel thinks the first 2 marks as what needs to be selected.
Has got me perplexed; anyone out there got a solution please.
2 Answers
- BT_BotLv 57 years agoFavorite Answer
Don't know what you want to do with IF(A2=VALUE("1") but if you want to find the text "1" in your SUBSTITUTE formula then you need to use double quotation marks for any one quotation mark within quotes (confused, yet?).
So to replace "1" with ~:
=SUBSTITUTE(A1, """1""", "~")
- ?Lv 57 years ago
Not sure if this is what your asking, but you can strip the quotes first. Assuming A1 contains "1", you can enter =SUBSTITUTE(A1, """", ""). This returns the one by itself without the quotes. Then you can do additional functions from there. Hope that helps.
