Results 1 to 19 of 19

Need to check if specific number is part of a string

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2024
    Location
    India
    MS-Off Ver
    2019
    Posts
    6

    Need to check if specific number is part of a string

    I have a string in cell A1, such as "asdfk1234jh", and cell B1 contains the number "1234". I want to determine if the exact number in B1 is present within the string in A1. Existing solutions only return "TRUE" if any part of the number is found, like "12" or "123", but I require a formula to confirm if "1234" specifically exists in A1.
    Attached Files Attached Files
    Last edited by Spammerworld; 04-17-2024 at 03:55 AM. Reason: Adding attachment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 03-21-2022, 09:21 AM
  2. [SOLVED] Code to check if a string is formatted correctly as a part number
    By Arnold Layne in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2021, 01:03 PM
  3. Underline a specific part of a text string (inc formulas) using VBA.
    By Oriya in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-06-2019, 05:56 AM
  4. [SOLVED] Check if part of string is a number or letter
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2015, 09:13 AM
  5. Check if the last part of entered string is an Integer
    By szpt9m in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-08-2014, 11:08 PM
  6. [SOLVED] Extracting specific part of the text string to another column
    By ssanjju in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 01-20-2013, 07:20 PM
  7. Finding specific text in string - Part II
    By Hardip in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-08-2006, 09:25 AM

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