excel formual for trim

  1. C

    Trim and Parentheses

    Good day, I'm trying to use a formula to change the name and bring in the correct format into the appropriate cell, but I can't seem to find the right combination? Example: Data in cell B1 = Doe, John (John D. Doe) my formula gives me = John Doe (John D. Doe) "=MID(G25&" "&G25,FIND("...

Some videos you may like

This Week's Hot Topics