Excel Text

[marty007]

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.

[#2 · Accepted solution]

@marty007 

=MID(A3,FIND(" ",A3)+1,100)&";"&LEFT(A3,FIND(" ",A3)-1)

I changed &”,”& to &";"& and it works in my spreadsheet.

[#3]

This did not work in my spreadsheet. Not sure why.

[#4]

@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.

[#5]

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.

[#6]

I'm happy it is fixed for you. As for how, by any chance did you copy and paste from MS Word or something?

[#7]

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.