Hi anyway im using a sorting code to sort my stuff. So I have a bunch of names to sort in order. How and if I can get around what I colored in red. I cant get it to be in order cause in the wording I have a couple of comma's in there. Is there a way to make that part read as one area other then picking it up as comma's. Thought maybe something like this, but this is wrong "Concrete Laborer - Local 6, 18A, 20"
Concrete Laborer - Local 6 18A 20 <--- This is I one tab for me but I need the comma's in there
Code:
SortOn:=xlSortOnValues, Order:=xlAscending, CustomOrder:= _ ,Line 4,Carp 151,Concrete 151,[COLOR="#FF0000"]Concrete Laborer - Local 6, 18A, 20[/COLOR],Concrete Laborer Foreman - Local 6,", DataOption:= _
xlSortNormal
Concrete Laborer - Local 6 18A 20 <--- This is I one tab for me but I need the comma's in there
Last edited: