+ Reply to Thread
Results 1 to 3 of 3

VBA Macro or Excel Function to recognise "NOUN" on a Col of data ?

  1. #1
    Registered User
    Join Date
    10-03-2015
    Location
    Perth
    MS-Off Ver
    2013
    Posts
    13

    VBA Macro or Excel Function to recognise "NOUN" on a Col of data ?

    I want to identify Prod Names ie Nouns from a list on Col A of my Workbook. Below is screenshot showing Col A (un-editied DATA) & Col B (Noun), which I have manually identified using human judgement.

    nouns.jpg

    Is it possible to use a VBA Macro or Excel Function to facilitate this ? The final output should not be more than 15 Chars.

    Attached is also the Sample Worksheet.

    The Final output does'nt have to be 100% perfect but close match.

    Thanks in Advance.
    Attached Files Attached Files
    Last edited by stefan27; 10-10-2015 at 03:37 AM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: VBA Macro or Excel Function to recognise "NOUN" on a Col of data ?

    Hi,

    Excel has no idea whether a string of characters contains a noun, and in passing even if it had wouldn't the word Carnauba in Carnauba Wax be an adjective

    What you're asking is for column B to recognise some characters which you as a human being know to be a noun. For Excel to do this you need to give it some rules.

    One such rule might be return the characters before the first digit so that for instance with Carburettor Cleaner 450ML American Dolphin the function
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    would return Carburettor Cleaner, but with Dashboard Wax Spray 450ML it wouldn't return Wax Spray but DashBoard Wax Spray. And arguably that would be correct since dashboard is a noun.

    So you need to be able to specify a list of rules before you can get anywhere near with this request.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: VBA Macro or Excel Function to recognise "NOUN" on a Col of data ?

    One way but not a 100% is to do a google search for List of Nouns. Put the Noun list into an excel sheet. Then with Scripting.Dictionary
    you can load all the nouns to Scripting.Dictionary And test if any of the sentence is in Scripting.Dictionary


    Just a thought
    Last edited by mike7952; 10-10-2015 at 04:53 PM.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  2. [SOLVED] Need Macro to compile data from "Weekly" sheets and sum up into "Monthly" summary sheet
    By mo4391 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2013, 07:25 PM
  3. [SOLVED] Need function to recognise "< or>" symbols
    By sam beginer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-10-2013, 03:15 AM
  4. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 AM
  5. Replies: 0
    Last Post: 07-17-2006, 09:45 AM
  6. [SOLVED] How to get excel to recognise &amp;quot;infinity&amp;quot; for asymptotes in charts
    By Joey Jubb in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-19-2006, 08:55 AM
  7. [SOLVED] How can I get a data table to recognise and display "N/A"?
    By Jennifer in forum Excel General
    Replies: 0
    Last Post: 03-16-2006, 01:55 PM
  8. Replies: 0
    Last Post: 03-16-2006, 01:52 PM

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