I have a column that is text but is a long string and I would like to sort
using a piece of the data. each time I try I get an error.
Example: HEJ,FEJ,123456,987654,111122,223333,444555,
How could I sort this column by 223333?
--
clcnewtoaccess

You could try using a helper column with a formula like this
=MID(A2,30,6)
and then sort by that. (this assumes your data is all similar in
format/start length)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"clcnewtoaccess" wrote:

I have a column that is text but is a long string and I would like to sort
using a piece of the data. each time I try I get an error.
Example: HEJ,FEJ,123456,987654,111122,223333,444555,
How could I sort this column by 223333?
--
clcnewtoaccess

it does not show up in the same location every time, some times there are
more and some times there are less.
--
clcnewtoaccess


"Luke M" wrote:

You could try using a helper column with a formula like this
=MID(A2,30,6)
and then sort by that. (this assumes your data is all similar in
format/start length)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"clcnewtoaccess" wrote:

I have a column that is text but is a long string and I would like to sort
using a piece of the data. each time I try I get an error.
Example: HEJ,FEJ,123456,987654,111122,223333,444555,
How could I sort this column by 223333?
--
clcnewtoaccess

Hi,

Select the column of data (say column A) and choose the Data, Text to
Columns command. You data looks like it is comma delimited, if so choose
Delimited, Next, Comma, Next, and select each column you don't need and
select the Skip (do not import) option, set the destination cell to column B
and click Finish. Sort on this new column.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"clcnewtoaccess" wrote:

it does not show up in the same location every time, some times there are
more and some times there are less.
--
clcnewtoaccess


"Luke M" wrote:

You could try using a helper column with a formula like this
=MID(A2,30,6)
and then sort by that. (this assumes your data is all similar in
format/start length)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"clcnewtoaccess" wrote:

I have a column that is text but is a long string and I would like to sort
using a piece of the data. each time I try I get an error.
Example: HEJ,FEJ,123456,987654,111122,223333,444555,
How could I sort this column by 223333?
--
clcnewtoaccess

I would just break it all into separate cells using datatext to
columnsde-limited by space.

Select all columns and sort on whichever column you want.


Gord Dibben MS Excel MVP

On Mon, 9 Feb 2009 10:11:01 -0800, clcnewtoaccess
wrote:

I have a column that is text but is a long string and I would like to sort
using a piece of the data. each time I try I get an error.
Example: HEJ,FEJ,123456,987654,111122,223333,444555,
How could I sort this column by 223333?

that works great but I ran into another problem. I found that there is data
entered multiple times on the same row. Do you know a way to get rid of the
multiples?
--
clcnewtoaccess


"Gord Dibben" wrote:

I would just break it all into separate cells using datatext to
columnsde-limited by space.

Select all columns and sort on whichever column you want.


Gord Dibben MS Excel MVP

On Mon, 9 Feb 2009 10:11:01 -0800, clcnewtoaccess
wrote:

I have a column that is text but is a long string and I would like to sort
using a piece of the data. each time I try I get an error.
Example: HEJ,FEJ,123456,987654,111122,223333,444555,
How could I sort this column by 223333?