I have a small problem and I hoped someone here could help me, because I'm not very good with Excel.
I have this formula
=TRIM(MID(A1,FIND(",",A1)+1,1000))&" "&LEFT(A1,FIND(",",A1)-1)
And I need a formula that will do this for me:
I have John, Smith; Alexander, Grimes and with the formula it will turn into Smith John; Grimes Alexander
PS: I don't want to necessarily lose the comma, but in most of the formulas I found, It would turn John, Smith into John Smith,.
Can anyone help?
Bookmarks