T
Todd
I have a sheet with the following
column a = 3 digit zip
column b, c, d, & contain a text territory designation
a b c d e
Example: 917 SE/PR W7 W8 W9
I need the columns b to e to be sorted left to right
alphabetically.
so "701 SE8 SE7 E7"
would look like like
701 E7 SE7 SE8
the thing is that you may only have somethin in B or B&C
and then the rest blank.
We are leaving the column A thing where it is.
Thanks for your time.
Todd
column a = 3 digit zip
column b, c, d, & contain a text territory designation
a b c d e
Example: 917 SE/PR W7 W8 W9
I need the columns b to e to be sorted left to right
alphabetically.
so "701 SE8 SE7 E7"
would look like like
701 E7 SE7 SE8
the thing is that you may only have somethin in B or B&C
and then the rest blank.
We are leaving the column A thing where it is.
Thanks for your time.
Todd