Hey all,
I'm trying to insert spaces between numbers and letters, but want to do so only with certain conditions in place. Each rule should be within its own formula, since the rules must follow a certain order to avoid any problems. Here are the rules in order:
Let "A" represent all letters and "1" represent all numbers
1. "AA1" -> "AA 1"
2. "A1A" -> "A 1A"
3. "1AA" -> "1 AA"
4. "1A " -> preserve. IF "A" = "N", "S", "E", "W", then "1A " -> "1 A "
Let me know if you can help me figure this one out.
Thanks!!
Bookmarks