Results 1 to 12 of 12

EXTRACT Data, Left Side of Character "/" - various conditions

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    EXTRACT Data, Left Side of Character "/" - various conditions

    Hi,
    I want to Extract Data from Left side of character "/"
    Data looks like :

    12345678/001
    BKJ12345/009
    JG123456/099 - name 2
    77661199/008 - name 1


    01. IF all are Numbers (...all in left side of "/")
    02. IF first two are letters and the rest numbers (...in left side of "/")
    03. IF first 3 are letters and the rest numbers
    04. IF Left side =K2 (data in K2)

    Thank you all
    Last edited by ionelz; 03-08-2021 at 08:05 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 14
    Last Post: 03-01-2021, 10:04 AM
  2. Replies: 14
    Last Post: 05-11-2020, 07:47 AM
  3. Replies: 4
    Last Post: 10-13-2018, 10:15 PM
  4. Replies: 35
    Last Post: 01-13-2016, 02:16 AM
  5. [SOLVED] Trim left, but only if the first 3 character start with "The"
    By firstsgt1978 in forum Excel General
    Replies: 7
    Last Post: 03-25-2014, 11:47 AM
  6. [SOLVED] How to remove all Zero"0" & space from left side
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2013, 05:37 AM
  7. Extract values on either side of "+"
    By Ada01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-28-2008, 02:09 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1