Split a number using LEFT and Right Formulas

Vincent Carranza

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

Mark Cronk

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

Mark Cronk

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

Vincent Carranza

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)

Mark Cronk

Hi Vincent,

Glad you found a solution. Thank you for contributing to the Community.

Mark