Results 1 to 5 of 5

Text.StartsWith Test to Determine Value

Threaded View

AllisterB Text.StartsWith Test to... 04-03-2021, 04:51 AM
AliGW Re: Text.StartsWith Test to... 04-03-2021, 05:02 AM
AllisterB Thankyou that worked nicely.... 04-03-2021, 05:57 PM
bebo021999 Re: Text.StartsWith Test to... 04-03-2021, 11:40 PM
AliGW Re: Text.StartsWith Test to... 04-04-2021, 02:52 AM
  1. #1
    Forum Contributor
    Join Date
    07-10-2020
    Location
    New Zealand
    MS-Off Ver
    365 personal
    Posts
    324

    Text.StartsWith Test to Determine Value

    Hi

    I have a table of Names - depending on the first two (Upper or Lower Case) characters I wish to put a value into a new column called Value

    Al is 10
    Be is 20 and
    Bo is 30.

    In my real solution, I have not 3 but 25.
    What is the best Power Query Solution - doe sit use Text.StartsWith?

    Thanks

    Allister
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] StartsWith Formula??
    By tisimp14 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-06-2018, 02:26 PM
  2. Logical Test to determine sheet calculation
    By AndyGW in forum Excel General
    Replies: 2
    Last Post: 05-13-2017, 03:37 PM
  3. Referencing a cell to determine operator in IF Logical Test
    By JGrange in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-07-2014, 05:17 AM
  4. Determine if one of multiple test string values is in a cell
    By marcusm7a in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-25-2012, 02:42 PM
  5. What can be used for .startswith command in VB
    By sisi001 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-05-2011, 03:17 PM
  6. Replies: 3
    Last Post: 09-29-2010, 12:22 PM
  7. VBA test to determine if cell has a formula or value
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-28-2008, 07:40 AM

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