Results 1 to 4 of 4

Formula to return first 3 numbers in account code

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-09-2009
    Location
    Columbus. Ohio
    MS-Off Ver
    Excel 2000
    Posts
    199

    Formula to return first 3 numbers in account code

    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
    =IF(L6="","",LEFT(L6,1) + 0)
    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
    Last edited by Jogier505; 08-03-2010 at 03:47 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1