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