Street Sort
- WWS36
- Member
- Posts: 57
- Joined: Mon May 21, 2007 11:04 am
- Location: N. Ogden, UT
Street Sort
Where can I get my ward sorted by Street address instead of Alphabetically?
- sbradshaw
- Community Moderators
- Posts: 6252
- Joined: Mon Sep 26, 2011 9:42 pm
- Location: Utah
- Contact:
Re: Street Sort
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.
- WWS36
- Member
- Posts: 57
- Joined: Mon May 21, 2007 11:04 am
- Location: N. Ogden, UT
Re: Street Sort
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)
- sbradshaw
- Community Moderators
- Posts: 6252
- Joined: Mon Sep 26, 2011 9:42 pm
- Location: Utah
- Contact:
Re: Street Sort
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.
- WWS36
- Member
- Posts: 57
- Joined: Mon May 21, 2007 11:04 am
- Location: N. Ogden, UT
Re: Street Sort
Tell me about it. I'm doing the whole Stake!