I am using a program that will save a report as Excel. In this report I have
one column with First and Last name. I try text to columns to separate but
it won't work. I have to physically put a space in between the first and
last name to achieve this. Is there a way to do this without having to
manually put in the space?