+ Reply to Thread
Results 1 to 3 of 3

Problem with LEFT and MID

  1. #1
    Registered User
    Join Date
    10-19-2018
    Location
    Arkansas
    MS-Off Ver
    MS Excel for Mac 365
    Posts
    29

    Problem with LEFT and MID

    Please Login or Register  to view this content.
    I'm attempting to create a 3 digit number from a 4 digit number by removing the number in the second position.

    1025 becomes 125
    2056 -> 256

    The formula above isn't doing it.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    15,957

    Re: Problem with LEFT and MID

    Here is an alternate solution

    =(LEFT(A1,1) & RIGHT(A1,2))*1

  3. #3
    Registered User
    Join Date
    10-19-2018
    Location
    Arkansas
    MS-Off Ver
    MS Excel for Mac 365
    Posts
    29

    Re: Problem with LEFT and MID

    That will do it.

    Thanks

+ Reply to Thread

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