Thank you so much for the response Hilary. So I've cleaned up the AD and now I have First.Last but having trouble with the translate function. Does this look correct translate(., ".", " ")
Also FYI I'm using the translate function to make it all caps that works and it looks like this translate(., ...