If you want to copy only specific text before or after a specific character, you need to combine some Excel text functions. In my case I had Lastname, Firstname output from a database where the name was placed into one cell. To remove the unwanted “,” and separate the surname and first name into separate cells, I did this:

  A B C
1 Name LastName FirstName
2 Walker, Johnny Walker Johnny
3   =LEFT(A2,FIND(“,”,A2)-1) =RIGHT(A2,LEN(A2)-FIND(“,”,A2))