Alphabetized Single Cell

**lkurrt** · 09-19-2013, 11:19 AM

Is there a way I can alphabetized this single cell Column G and Row 2? And apply it to all the cell in the column?Untitled2.jpg

**L-Drr** · 09-19-2013, 11:43 AM

You want to alphabetically sort your file on column G, right?

Select all cels, under Data click Sort, select column G, click OK

**lkurrt** · 09-19-2013, 11:51 AM

All of the data in the columns moves. See this is want i want to happen. CNN ESPN ESPN2 TBS TNT TLC-W USA FNC going to CNN ESPN ESPN2 FNC TBS TNT TLC-W USA. All words now are alphabetize accordingly. And then apply this to all cell within the column.

**L-Drr** · 09-19-2013, 01:30 PM

I think you'd have to split column G and then sort from left to right:

select column G
click Text To Columns under Data and set space as delimiter
then, for each row individually (don't know a better way), click Sort, click options and set from left to right
when all is done, use CONCATENATE or & to put the values back together again

Maybe there's a faster way but I wouldn't know...