Seperating a list with commas in it

  • Thread starter Thread starter shaneras
  • Start date Start date
S

shaneras

Hi,

I have a list of 3,000 words that I need to seperate words with comma
and those without. Example:

y2
ye
year,Nw48
yhit,A$I0
yoffset,Jq

How can I get all the words that do not have a comma after them t
sort?

THanks
 
A little unclear about your needs.

Do you want to separate them or sort them?

One method would be use Auto-Filter to filter them and copy to a new sheet and
do your sort there.

You could delete one set or the other from the first sheet then copy the
sorted set back in.

Select the column then Data>Filter>Auto-filter. Click on the drop-down arrow
and select Custom>Does not Contain> ","(no quotes)

Now Edit>Go To>Special>Visble Cells Only>OK

Copy the visible cells to a new sheet.

Delete the visible cells from the original sheet then bring them back in from
other sheet.

Lots of options to separate and/or sort.

Gord Dibben Excel MVP
 
Another option:

Use a helper cell and put this formula:
=countif(a1,"*,*")
and drag down

This will return a 0 or 1 and you can sort by that column.
 
Back
Top