Have you tried escaping with an additional double-quote? By escaping a character, you are telling Excel to treat the ” character as literal text.
= "Maurice ""The Rocket"" Richard"
More Related Contents:
- Want to concatenate multiple row data in in cell along with its values if present. Emp Id should not come if no data available infromt of it
- Excel Number Separation [closed]
- Calculation is wrong, Rounding wrong
- Excel formula checklist in employees
- Sequence of numbers based on start and end value of 2 cells [closed]
- Excel VBA – How to add dynamic array formula
- Return empty cell from formula in Excel
- TEXTJOIN for xl2010/xl2013 with criteria
- Difference between date and time w/out work week Excel
- How can I perform a reverse string search in Excel without using VBA?
- Filling any empty cells with the value above
- Excel Formula for Inventory
- Count Unique values with a condition
- Two column lookup in table array using INDEX and MATCH
- Using UNIQUE with non-adjecent columns on different sheets
- Count unique values in Excel
- Concatenate column headers if value in rows below is non-blank
- If two cells match, return value from third
- What does — do in Excel formulas?
- How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
- Using the value in a cell as a cell reference in a formula?
- How to list all possible combinations of the values in three columns in excel?
- Excel – extracting top 5 values
- CountIf With Filtered Data
- How to split texts from dynamic range?
- Excel: Search for a list of strings within a particular string using array formulas?
- How to count cells in a range with a value less than another cell in excel?
- Extract the last substring from a cell
- How to extract text within a string of text
- Excel: How to gather unique values in one column that are associated with duplicates in another column?