Re: Splitting data into two columns

From: RagDyeR (ragdyer_at_cutoutmsn.com)
Date: 09/11/04 

Date: Sat, 11 Sep 2004 12:06:27 -0700

>From your description, I would guess that you imported this list of names,
and the spaces between the names are "non-breaking" spaces.

When you go to the second window of TTC, under "DataPreview", WYSIWYG.
Are the names separated in this window by a black line?

Try this:

Copy some of these names to a column, and you key in some names yourself,
using the normal space bar.
Now, when you go to the second window of TTC, scroll up and/or down, and see
if you can tell the difference between what you entered and what your
original data looked like. 

-- 
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"RamProwler" <RamProwler@discussions.microsoft.com> wrote in message
news:71BFC580-B6C2-4B7F-8194-A512FC65D13C@microsoft.com...
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
> > >
> > >
> > >
> >
> >
> >
Loading