I have a name setup in Column A and in the format Spy, Burt I want to setup a formual that will convert to Burt Spy in column B. I remember doing this in the past, but for some darn reason I cannot figure it out now. Any suggestions pretty please?