+ Reply to Thread
Results 1 to 7 of 7

vlookup,replace word with single character

  1. #1
    Registered User
    Join Date
    11-04-2009
    Location
    va
    MS-Off Ver
    Excel 2003
    Posts
    27

    vlookup,replace word with single character

    Hello all and good day..

    I am trying to perform a search and when it finds one of the three words it will strip all the letters but the first..

    Many Thanks
    Attached Files Attached Files
    Last edited by vascott01; 03-05-2010 at 09:04 AM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: vlookup,replace word with single character

    I am not sure what you mean.. what are the criteria, what are the 3 words.. can you elaborate a bit?
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    11-04-2009
    Location
    va
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: vlookup,replace word with single character

    sure sorry about that...When you query and it returns apple...apple would be converted to A...Banana would be returned with B etc...

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: vlookup,replace word with single character

    I think I got that, but not sure about what you are querying..

    if it is the actual formula you got there, then:

    =LEFT(VLOOKUP(A4,produce!$A$2:$F$233,2,FALSE))

  5. #5
    Registered User
    Join Date
    11-04-2009
    Location
    va
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: vlookup,replace word with single character

    on the worksheet "Store"..When I try to pull the information from the "produce" tab which is a generated report. I want to pull the information...but when I do...I want to strip all lettering except the first and be able to do that for all the other pulled information in the B column. In the first example...Cell B4 pulls Apple...which I want but I do not want "pple" just the letter A (Trim ??). I have a space requirement as my real workbook has many other pulled information that needs to be viewed on the monitor...

    Does this help..

    technically only those three words used in my example will be pulled from the report.

    I know I could slide the cell over to squeeze it enough to only show the Letter A, B, C etc... but was wondering if a formula of some sorts could do the job...
    Last edited by vascott01; 03-05-2010 at 07:31 AM. Reason: additional input

  6. #6
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: vlookup,replace word with single character

    Have you tried the formula above?

  7. #7
    Registered User
    Join Date
    11-04-2009
    Location
    va
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: vlookup,replace word with single character

    I did..and it came back saying true... I tried again and it worked... Thanks again


    Kudo's again....and thanks for all your problem solving capabilities to this forum.....

+ 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