Member
Where can I get my ward sorted by Street address instead of Alphabetically?
Street Sort
Community Moderators
There isn't currently a way to do that in Leader and Clerk Resources. You should send this as feedback using the "Do You Have Feedback" link at the bottom of the page. I've also sent feedback on this in the past. Some of the other columns are sortable, but not the address. Phone number would also be handy to sort, to organize by area code.
Samuel Bradshaw • If you desire to serve God, you are called to the work.
Member
A good brother sent these EXCEL formulas to me and they work like a charm!!!
THanks, WWS
try these
=LEFT(A1,SEARCH(" ",A1)-1)
=MID(A1,SEARCH(" ",A1)+1,50)
or these
=LEFT(A2,SEARCH(" ",A2,SEARCH(" ",A2)+1)-1)
=MID(A2,SEARCH(" ",A2,SEARCH(" ",A2)+1)+1,50)
THanks, WWS
try these
=LEFT(A1,SEARCH(" ",A1)-1)
=MID(A1,SEARCH(" ",A1)+1,50)
or these
=LEFT(A2,SEARCH(" ",A2,SEARCH(" ",A2)+1)-1)
=MID(A2,SEARCH(" ",A2,SEARCH(" ",A2)+1)+1,50)
Community Moderators
It's a lot of work to keep a separate spreadsheet, though – it'd be nice if Leader and Clerk Resources could sort.
Samuel Bradshaw • If you desire to serve God, you are called to the work.
Member
Tell me about it. I'm doing the whole Stake!