+ Reply to Thread
Results 1 to 3 of 3

Problem using "left" function in VBA

  1. #1
    Registered User
    Join Date
    04-26-2011
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    48

    Problem using "left" function in VBA

    Hi. I'm trying to extract only the 2 leftmost characters from the text in cell C2. I tried the procedure below, but when I test it with debug.print, it only prints false. This is part of a larger program, but I can't get past this first problem. Here's the code and I've attached the spreadsheet. Thanks for any help.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by egavasrg; 12-09-2011 at 09:05 PM.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Problem using "left" function in VBA

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-26-2011
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: Problem using "left" function in VBA

    Thank you. This is exactly what I needed. I really appreciate the quick response too.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1