+ Reply to Thread
Results 1 to 2 of 2

Extract Alpha from A String and Compare with another String!

  1. #1
    Registered User
    Join Date
    08-16-2007
    Posts
    4

    Extract Alpha from A String and Compare with another String!

    Hello...

    I have a problems here. The problems is attached in the file. I wanna extract alpha/char from a string. Example: I wanna extract the words "(M)" with the bracket from the string "Toothbrush (M)" in column A. After extracting the (M) out, I wanna do a validation to compare the (M) in column B with another data in column C, if the (M) is same as the data called "Medium" in column c, the validation will return "Match" in the column d!

    Can anyone help me out? Thanks you very much! Yr help is greatly appreciated!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-09-2005
    Location
    England
    MS-Off Ver
    2007
    Posts
    1,500
    Perhaps this? Does it do what you want?

    Regards

    Dav
    Attached Files Attached Files

+ 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