+ 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
    33

    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
    17,889

    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
    33

    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)

Similar Threads

  1. [SOLVED] Problem with LEFT function
    By rookie210 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-13-2014, 01:03 PM
  2. LEFT RIGHT MID complex problem
    By ch9sab in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-17-2014, 05:57 AM
  3. [SOLVED] IF, LEFT, MID problem
    By ktbb0312 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-23-2013, 02:41 PM
  4. Macro that makes a custom footer (left and center section) - problem
    By Vogelmann in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2012, 03:41 AM
  5. Excel 2007 : Problem with 'left' and 'if' functions
    By taimur32 in forum Excel General
    Replies: 3
    Last Post: 08-26-2011, 03:48 AM
  6. [SOLVED] Direction problem in inserting strings using right to left language
    By Amir in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2005, 10:05 AM
  7. ADO Recordset Problem -- Left Join
    By ExcelMan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-24-2005, 06:07 AM

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