problem sorting data

C

clcnewtoaccess

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

Luke M

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

clcnewtoaccess

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

Shane Devenshire

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

Gord Dibben

I would just break it all into separate cells using data>text to
columns>de-limited by space.

Select all columns and sort on whichever column you want.


Gord Dibben MS Excel MVP
 
C

clcnewtoaccess

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

Gord Dibben

See answer from Chip Pearson at your other post to get rid of duplicates
across a row.


Gord
 
Top