Re: Splitting data into two columns

From: RamProwler (RamProwler_at_discussions.microsoft.com)
Date: 09/11/04 

Date: Sat, 11 Sep 2004 11:39:02 -0700

Are you on messenger? Perhaps I could send the file to you to look at and
see if there is something strange about my file that would prevent it from
splitting into two columns?

"RamProwler" wrote:

> Yes, and I even cut a portion of the list out and worked on that piece alone
> too, playing with changing both the consective delimiters and final location.
> It doesn't appear to do anything but just repaste the existing data into one
> new column. I'm perplexed and frustrated. Any new ideas, I really
> appreciate your assistance.
>
> "RagDyeR" wrote:
>
> > Did you select your entire list before you started?
> > --
> >
> > Regards,
> >
> > RD
> > --------------------------------------------------------------------
> > Please keep all correspondence within the Group, so all may benefit !
> > --------------------------------------------------------------------
> >
> > "RamProwler" <RamProwler@discussions.microsoft.com> wrote in message
> > news:27A651F9-1091-4154-9BBB-7A86B3A1F597@microsoft.com...
> > That didn't work for me. There was no creation of the data in two columns!
> > I don't understand. It looks like it should work
> >
> > "RagDyeR" wrote:
> >
> > > <Data> <TextToColumns>
> > > Check "Delimited", then <Next>
> > > Check "Space", then <Finish>.
> > > --
> > >
> > > HTH,
> > >
> > > RD
> > > ==============================================
> > > Please keep all correspondence within the Group, so all may benefit!
> > > ==============================================
> > >
> > > "RamProwler" <RamProwler@discussions.microsoft.com> wrote in message
> > > news:2E2C49BB-8588-440A-8A30-DA2D65A57322@microsoft.com...
> > > I have data I want split into two columns. It currently is first name,
> > last
> > > name in one column. I'd like to make two columns out of it, separate
> > first
> > > name and last name. There is a space between the first and last name.
> > How
> > > can I split this column into two?
> > >
> > > Thanks bunches
> > >
> > > Carolyn
> > >
> > >
> > >
> >
> >
> >