Split a number using LEFT and Right Formulas
I have a location number that is 6 digits long. I am trying to create a formula using LEFT and Right to add a dash after the first 4 numbers.
EX: if the location number is 123456, I want to create a formula to show 1234-56
Best Answer
-
Hi @Vincent Carranza ,
Try:
=LEFT([location]@row,4) + "-" + RIGHT([location]@row, 2)
You'll need to replace [location] with the name of your location number column.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @Vincent Carranza ,
Try:
=LEFT([location]@row,4) + "-" + RIGHT([location]@row, 2)
You'll need to replace [location] with the name of your location number column.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
That worked! Thank you Mark. I was using "&" instead of "+".
This was the final formula that worked: =LEFT([Primary Column]1, 4) + "-" + RIGHT([Primary Column]1, 2)
-
Hi Vincent,
Glad you found a solution. Thank you for contributing to the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
Check out the Formula Handbook template!