Thanks .. But using the Trim doesn't fix that .Value2 = Application.Trim(v) Is there a way to fix the output as appeared in Post #46?