Heidi,

Lets suppose yo have Keith Atkinson in A1, what does the formula below
return?

=CODE(MID(A1,6,1))

Mike

"Heidi" wrote:

Keith Atkinson
Jessica Bertrum
Gary Blenker
Pete Brang
Jeff Davies
Perry Ellering
Shannon Ellering
Kristen Finken
AIMEE GERADS
JON HINNENKAMP
KENNY HINNENKAMP
Jeff Houston
Ryan Imdieke

This is an example of the column of names. Excel is not recognizing the
space that is already between the two names, and when I add a space to conert
to two columns, then I have to physically remove the extra space.

"Mike H" wrote:

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?