Re: Splitting data into two columns

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

Date: Sat, 11 Sep 2004 11:37:05 -0700

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
> >
> >
> >
>
>
>