Forum Discussion
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 giv...
=MID(A3,FIND(" ",A3)+1,100)&";"&LEFT(A3,FIND(" ",A3)-1)
I changed &”,”& to &";"& and it works in my spreadsheet.
=MID(A3,FIND(" ",A3)+1,100)&";"&LEFT(A3,FIND(" ",A3)-1)
I changed &”,”& to &";"& and it works in my spreadsheet.
- This did not work in my spreadsheet. Not sure why.
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.
- 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.
