Stumped on formula

MRiley88

I run a report out of our Accounting system and it has the store number included in the account number, along with what we refer to as our Sub Project number (example: NS 0046 - AE). I am trying to add a formula to Sub Project column to result in the Sub Project number (Example: row 1 = AE, row 2 = CONST). Is that possible or just wishful thinking on my part?

Thanks!

Jeff Reisman

If all your store number values are like "NS 0000 - ", this will start at the 11th position from the left and take the next 5 characters. So "AE", or "DB", or "Other", etc.

=MID([Store Number]@row, 11, 5)

Jeff Reisman

If all your store number values are like "NS 0000 - ", this will start at the 11th position from the left and take the next 5 characters. So "AE", or "DB", or "Other", etc.

=MID([Store Number]@row, 11, 5)

MRiley88

You, sir, are glorious! I knew I was making it harder than it needed to be. Works perfectly!