Re: Splitting Cell Data?

From: Ragdyer (RagDyer_at_cutoutmsn.com)
Date: 06/12/04 

Date: Sat, 12 Jun 2004 12:59:10 -0700

You could try using "TextToColumns".

Make note of the column letter at the end of the data list.
Select the address column, then:
<Data> <TextToColumns> <Next>,
Click in "Space", then <Next>.

Now, count the number of columns that are displaying the separations.
Make sure that you have that many *empty* contiguous columns at the end of
the data list.
In the "Destination" window, enter the empty column at the end of the list,
Then <Finish>.

You now have your addresses broken up into several columns.
You can now choose any column you wish as sort key 1, and any other as sort
key 2 ... and so on.

When your finished sorting, simply delete these "helper" columns if you
wish. 

-- 
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dax Arroway" <Dax Arroway@discussions.microsoft.com> wrote in message
news:CC407BF6-C817-4E3F-BC5C-C64E9E3CA6EA@microsoft.com...
> OK here's a great one.  Check this out.  I have a simple one page
spread*** of addresses.  My client wants me to sort/filter the data so
that it is sorted by street name first, then by address number.  The problem
is that the spread*** has 30,000 entries and the Address Column contains
the street number and street name (i.e. 12345 Park Drive Blvd. Apt #345).
So my question is: does anyone know how I can separate the street number
portion of the address from the street name portion of the address to be put
into two separate columns so I can sort them?
> Thanks in advance,
> Dax
Quantcast