This can be accomplished by doing look up of the state names. For this you would need to create a list of states and use formula.
Please see attached file with states names and a formula in B2
This can be accomplished by doing look up of the state names. For this you would need to create a list of states and use formula.
Please see attached file with states names and a formula in B2
Last edited by AlKey; 10-21-2014 at 02:51 PM. Reason: Updated formula on spreadsheet.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks