WEBMay 2, 2006 · Change Smith, John to John Smith. This seems very easy right? Well, the name list that I am currently. converting is a little querky. I would like to do this----> Cell.A1 [Smith, John] Cell.A2 [John Smith] Here is hwere it gets a little tricky....I need to nest the TRIM function to.