+ Reply to Thread
Results 1 to 2 of 2

Finding string Text

  1. #1
    Registered User
    Join Date
    07-25-2008
    Location
    England
    Posts
    8

    Finding string Text

    Sorry if the Title is missleading, i cant think of anything better without writting a whole sentence in there!

    Hi, I have had a brief look around the forums and cannot find the answer, but here it is:

    I have a number of tabs on my workbook, in which im taking the tab name in a record on a sheet, this is fine. Now the last word in the tab name is a month, but the month is sometimes written as 'Aug' or 'August'!
    As what im trying to is to take that month and use it in another tab in the same worksheet, but i want it set as a full name (e.g. August, July, September etc).
    Obviously, i cant do an if statment saying (written in pseudocode)
    Please Login or Register  to view this content.
    and if the value is 'August', it will go onto the Else, what i want is the IF to pick up Aug* (so either 'Aug', or anything after that like 'August')

    Anyone have any ideas how to do this?

    Sorry if this seems confusing

    Regards,

    David

  2. #2
    Forum Contributor SOS's Avatar
    Join Date
    01-26-2004
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    327
    Hi Dave31,

    You could use the left function like:

    Please Login or Register  to view this content.
    Hope this helps

    Seamus

+ 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. Find row number of text string in a range of cells
    By Steven Fleck in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-06-2013, 08:38 PM
  2. Replies: 4
    Last Post: 02-06-2012, 06:53 PM
  3. Select and paste part of a text string ?
    By richardeallen in forum Excel General
    Replies: 3
    Last Post: 05-16-2008, 10:34 AM
  4. Using a countif function for text string data.
    By Stevie-B in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-11-2008, 11:54 AM
  5. Convert cell reference to text string
    By packe in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-08-2007, 09:56 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