Advertisement
crexin

Excel-Fix Names that have Extra data appended to name

Aug 17th, 2017
242
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. Fix Names that have common text appended on the full name.
  2.  
  3. i.e.
  4. FullName Original Name
  5. John Doe-Updates John Doe
  6.  
  7. This can be fixed in Excel using a formula like the following by using the "-" character as the character to look at and retrieve all the text to the left of it.:
  8. =LEFT(A2,FIND("-",A2)-1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement