+ Reply to Thread
Results 1 to 6 of 6

Remove iNdex chars From Left

  1. 05-21-2009, 03:46 AM #1
    teodormircea is offline
    Registered User
    Join Date
    02-25-2008
    Posts
    29

    Exclamation Remove iNdex chars From Left

    Hello Forum

    I made in a macros this formula :LEFT(RC[-1],(LEN(RC[-1])-2))
    is removing from left side an index , like in this example '
    9117 - 570-65CE49D-B4-7 to obtain 9117 - 570-65CE49D-B4

    so here is my code,

    is with an userform, but it gaves me an error, that my procedure is invalid
    Please Login or Register  to view this content.
    Last edited by teodormircea; 05-21-2009 at 08:19 AM.
    Reply With QuoteRegister To Reply
  2. 05-21-2009, 03:56 AM #2
    Phil_V is offline
    Forum Contributor
    Join Date
    02-23-2006
    Location
    Near London, England
    MS-Off Ver
    Office 2003
    Posts
    770

    Re: Remove iNdex chars From Left

    You had better wrap your code in code tags before it gets spotted.
    Edit your post, click the 'Go Advanced' button, then select your code, and then click the '#' button above the edit area.
    It makes it much easier for others to read your code then
    Reply With QuoteRegister To Reply
  3. 05-21-2009, 04:01 AM #3
    teodormircea is offline
    Registered User
    Join Date
    02-25-2008
    Posts
    29

    Re: Remove iNdex chars From Left

    Thanks, didn't to make truble
    Reply With QuoteRegister To Reply
  4. 05-21-2009, 05:24 AM #4
    teodormircea is offline
    Registered User
    Join Date
    02-25-2008
    Posts
    29

    Re: Remove iNdex chars From Left

    I think i found the problem, it doesn't work if a have blank cells.
    How to avoid this problem
    Reply With QuoteRegister To Reply
  5. 05-21-2009, 06:36 AM #5
    Phil_V is offline
    Forum Contributor
    Join Date
    02-23-2006
    Location
    Near London, England
    MS-Off Ver
    Office 2003
    Posts
    770

    Re: Remove iNdex chars From Left

    I have not used userforms, but if the blank cell is causing you problems then the alteration below should overcome it for you:

    Please Login or Register  to view this content.
    becomes

    Please Login or Register  to view this content.
    If you find the response helpful please click the scales in the blue bar above and rate it
    If you don't like the response, don't bother with the scales, they are not for you
    Reply With QuoteRegister To Reply
  6. 05-21-2009, 08:19 AM #6
    teodormircea is offline
    Registered User
    Join Date
    02-25-2008
    Posts
    29

    Re: Remove iNdex chars From Left

    here a solution, with a condition for blanks
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1