Results 1 to 4 of 4

Search and return values with asterisk (*)

Threaded View

  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.

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. 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