Forum Discussion
Terp
4 years agoAdvocate III
Calculated Column: Return Two (2) Characters After Comma
I was trying to figure out how to do a reverse concantination, per se, and got close...but can't get it right. 🙂 I have a long string of city/MSA information and I want to join this city table t...
- 4 years ago
Terp , On Top of your formula use left(<Current formula>,2)
I think that might help
amitchandak
4 years agoSuper User
Terp , On Top of your formula use left(<Current formula>,2)
I think that might help
- Terp4 years agoAdvocate III
You, sir, are a genius....would have NEVER gotten that one right...did swap out right for left previously and played around, but would have never thought to use both. 🙂
It doen't seem intuitive/efficient, but it sure works! Many, many thanks, sir!