Willowdale
New Member
- Joined
- May 28, 2017
- Messages
- 14
We have in our stores a purchase order field. Unfortunately there is no data validation system in place and users can type whatever they want , so we end up with addresses and street names spelled slightly differently all over the place, making job summaries via downloaded excel files a pita (e.g. going thru it manually w copy and paste ) We get a list for invoices for the same po, but they look like this:
El Reeno Duplex
El Reno dupex
Reno Dup
Is there a way to have Excel apply some sort of data validation formula on the back end?
El Reeno Duplex
El Reno dupex
Reno Dup
Is there a way to have Excel apply some sort of data validation formula on the back end?