Results 1 to 9 of 9

extract 2 x specific characters, one text, one numeric from a cell in excel 365

Threaded View

  1. 03-06-2023, 12:51 AM #1
    VisionSmart
    VisionSmart is offline
    Forum Contributor
    Join Date
    04-22-2017
    Location
    AU
    MS-Off Ver
    Microsoft 365
    Posts
    304

    extract 2 x specific characters, one text, one numeric from a cell in excel 365

    Hello all

    Require the correct formula to extract 2 adjoining characters from an existing populated cell, one SAlpha, one Numeric and place the two characters in an adjacent cell please.
    Sere example attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. extract only 10 characters(numeric) in a cell
    By xatomicx in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-13-2022, 11:53 AM
  2. [SOLVED] Limit number of characters in a cell (4 numeric & 1 text)
    By Kenny Yip in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-19-2022, 04:19 AM
  3. [SOLVED] Extract specific number of characters if word in cell begins with specific text
    By Tapyr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2021, 06:29 PM
  4. Extract numeric value from a cell where Text and Numeric combined in a cell
    By Chandrahaas in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-07-2014, 10:58 AM
  5. [SOLVED] Need to extract words or text from a cell containing numeric / alpha-numeric and words
    By vatsan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-25-2014, 02:00 AM
  6. How can I extract numeric info from a specific cell from multiple workbooks?
    By surfing69 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-24-2013, 12:35 PM
  7. Formula Question- If first 3 characters of a cell contain text or numeric value
    By viinncceee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-11-2013, 07:26 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1