+ Reply to Thread
Results 1 to 4 of 4

Search and return values with asterisk (*)

  1. #1
    Registered User
    Join Date
    10-16-2020
    Location
    philippines
    MS-Off Ver
    10
    Posts
    4

    Search and return values with asterisk (*)

    Hello All,

    I am working on a file in where the search values have *. for example, I am searching of 05611011, in my search are, I have numbers that are in * and I am expecting that the result is 0561****. is it possible? thanks in advance.

    I have attached a file with the description for reference.
    Attached Files Attached Files
    Last edited by antonioj; 10-21-2020 at 12:17 PM.

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Search and return values with asterisk (*)

    can you clarify this?
    Quote Originally Posted by antonioj View Post
    and I am expecting that the result is 0561****.
    you mean you are searching for the literal value/string of 0561****? or you're searching for cell values that start with the numbers 0561?

  3. #3
    Registered User
    Join Date
    10-16-2020
    Location
    philippines
    MS-Off Ver
    10
    Posts
    4

    Re: Search and return values with asterisk (*)

    Hello Adam,

    I am searching for cell values that start with 0561. 0561**** is my expected return value

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Search and return values with asterisk (*)

    Using Power Query, I created a parameter that allows you to set the variables that you need. The attached file holds all the information. Fill in the data in I2 and K2 and then click on the Refresh Button on the PQ/Data Tab. If you want to understand this more, then click on the link below for a tutorial.

    https://www.youtube.com/watch?v=gK2yBpiITvI

    File is attached for your review and further info on PQ follows.

    Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

    It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

    - Follow this link to learn how to install Power Query in Excel 2010 / 2013.

    - Follow this link for an introduction to Power Query functionality.

    - Follow this link for a video which demonstrates how to use Power Query code provided.
    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)

Similar Threads

  1. [SOLVED] Return oldest date in range using asterisk as criteria
    By glomb175 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 06-01-2018, 03:54 PM
  2. [SOLVED] search table for unique values return values and corresponding cells to a different sheet
    By thara95 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-01-2017, 09:04 AM
  3. Numbers before 1st asterisk, 2nd asterisk, 3rd asterisk
    By stephme55 in forum Excel General
    Replies: 1
    Last Post: 08-23-2016, 12:57 AM
  4. Replies: 4
    Last Post: 10-01-2015, 11:01 AM
  5. Replies: 6
    Last Post: 03-12-2015, 01:35 AM
  6. Replies: 4
    Last Post: 12-21-2012, 10:35 AM
  7. [SOLVED] Search Multiple columns for criterion asterisk (*) and Return Numeric Label
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-14-2006, 02:00 PM

Tags for this Thread

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