Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse Site by Tags

Showing related tags and posts accross the entire site.
  • Re: Nesting "RIGHT", "MID", and "FIND" in a formula

    Gary I always use a UDF (User Defined Function) like that below. Public Function FindLastSpace(sInput As String ) As String Dim iLastSpacePos As Integer Dim iLengthOfString As Integer Application.Volatile True iLastSpacePos = InStrRev(sInput, " " , -1) iLengthOfString = Len(sInput) FindLastSpace...
    Posted to General (Forum) by Nick Hodge on Thu, May 29 2008
Page 1 of 1 (1 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.