jlbecker67
New Member
- Joined
- Mar 26, 2002
- Messages
- 8
Maybe this is simple, but I am not very good with excel. I want to write a formula to move data to another cell based on certain criteria.
Example: I have a spreadsheet with our county's property tax values with addresses. The addresses didn't split into columns right. Sometimes the street (st) got moved to the wrong column because there wasn't a direction on the address. How do I move all these two letter designations to the right columns without a lot of time?
Thank you very much,
Jerry
Example: I have a spreadsheet with our county's property tax values with addresses. The addresses didn't split into columns right. Sometimes the street (st) got moved to the wrong column because there wasn't a direction on the address. How do I move all these two letter designations to the right columns without a lot of time?
Thank you very much,
Jerry