+ Reply to Thread
Results 1 to 4 of 4

MID function problem

  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    117

    MID function problem

    so I'm trying to put a helper column in for the benefit of another function. On many sheets of my WB i have a date column where the date is entered and data for that row is subsequently entered. The date column is custom formatted so if i enter 1-8 it returns 01-AUG-13, this is fine. Now, for the benefit of another formula, in a hidden helper column i want to extract just the "AUG" part of the adjacent date cell. I tried using =MID(A2,4,3) but it returns a value of 87??? i tried to custom format but to no avail. any ideas???

  2. #2
    Valued Forum Contributor TheCman81's Avatar
    Join Date
    11-06-2012
    Location
    Edinburgh, UK
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    346

    Re: MID function problem

    You can use something like this

    =TEXT(A1,"mmm")
    Excel Guru in the making

    <----------If the question has been answered to your satisfication please click the Add Repuation star to the left

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,550

    Re: MID function problem

    =TEXT(A2,"mmm") try this

  4. #4
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: MID function problem

    Hello alfgrey I Hope this of your query is solved http://www.excelforum.com/excel-form...ml#post3434148
    If it is so mark http://www.excelforum.com/excel-form...ml#post3434148 as solved.

    Can you please upload a sample book of your data.
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

+ 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. Problem Inserting Round function into an IF function
    By Ash87 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2013, 05:37 PM
  2. IF function problem
    By d.i.y. man in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 04-20-2012, 08:57 AM
  3. Function problem
    By Geronimo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2011, 10:09 AM
  4. if function problem.
    By thupten in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-12-2008, 04:07 PM
  5. function problem
    By chindo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-10-2005, 10:35 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