How to create a formula to pull the first part of an order number into an adjacent column

cmseeton

Hello!

I am struggling to create a formula to pull the first part of an order number (our internal agency numbers) into a separate column so I can see how much each agent sends in each month. Screenshot of the order number below:

Isis Taylor

@cmseeton Is this what you are trying to accomplish?

If so use this formula in the Agent column.

=IFERROR(LEFT([Order Number]@row, 4), "")

Isis Taylor

@cmseeton Is this what you are trying to accomplish?

If so use this formula in the Agent column.

=IFERROR(LEFT([Order Number]@row, 4), "")

cmseeton

Thank you so much!!!! I greatly appreciate it!