Formula to return first 3 numbers in account code

[Jogier505]

I have a column with a list of codes as follows,

539-K600Z28
757-K600F87
757-K0033FZ
757-K0037F1
539-k0054s8
757-0056RP

The formula

Please Login or Register  to view this content.

returns only the first number. I am looking for a formula that will return the first 3 numbers, in this case.

757
539

Thank You
JImO

[daddylonglegs]

Hello Jim, you can just change the 1 to a 3......

=IF(L6="","",LEFT(L6,3) + 0)

[martindwilson]

deleted .........................................

[Jogier505]

DLL,

Thanks. Its easy when you know how!!

JIm O