Forum Discussion

marty007's avatar
marty007
Copper Contributor
Dec 01, 2021
Solved

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 gives me Groff,

I wrote the formula =LEFT(B8,FIND(" ",B8)-1)            and this gives me Matthew

I tried to combine them with =MID(B8,FIND(" ",B8)+1,100)&”,”&LEFT(B8,FIND(" ",B8)-1)

But this gives me a Name error that I can't figure out. I have attached my sample file.

 

6 Replies

    • marty007's avatar
      marty007
      Copper Contributor
      This did not work in my spreadsheet. Not sure why.
      • 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.

Resources