Hi,

Text to colums requires a delimeter or for your string to be split 'fixed
width' and it seems unlikely all your first names will be of the same length.
Post some sample data and someone may be able to help.

Mike

"Heidi" wrote:

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?