Forum Discussion

marty007's avatar
marty007
Brass Contributor
Dec 01, 2021

Excel Text

I have a column that contains the Full Name, such as Matthew Groff. I want to change the Full Name column to read Groff, Matthew I wrote the formula =MID(B8,FIND(" ",B8)+1,100)&”,”      and this giv...
Formulas and Functions
mtarler's avatar
mtarler
Silver Contributor

marty007  The problem is your curly quotes.  Look at the difference in the quotes around the comma (curly style) compared to the rest of the quotes:

Fix those quotes and you will be good.

marty007's avatar
marty007
Brass Contributor
Dec 01, 2021
I did that and it worked. I have no idea how I created those "wrong way" quotes. They don't appear on my keyboard. Thanks.
  • mtarler's avatar
    mtarler
    Silver Contributor
    Dec 02, 2021
    I'm happy it is fixed for you. As for how, by any chance did you copy and paste from MS Word or something?
    • marty007's avatar
      marty007
      Brass Contributor
      Dec 02, 2021
      In fact, I did. I was never aware that some programs create different types of quote marks. I will always remember to check from now on. Thanks again.

Resources