+ Reply to Thread
Results 1 to 1 of 1

Add substring to specific conditions

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Add substring to specific conditions

    Hello everybody
    I have some data in Column H
    Some data like that pattern
    Please Login or Register  to view this content.
    11 or 12 digits then a character then 11 or 12 digits

    If this pattern existed then using udf or formula to add the following substring
    Please Login or Register  to view this content.
    which represents a character and 4 digits

    The substring to be added after the first 11th or 12th digits and before the character existed
    and the same substring to be added at the end

    The result should be
    Please Login or Register  to view this content.
    Hope the example is clear
    I will attach a sample
    Attached Files Attached Files
    Last edited by YasserKhalil; 05-08-2015 at 05:14 AM.

+ 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. Replies: 3
    Last Post: 09-07-2014, 12:25 AM
  2. Search substring within range, report the substring found
    By Brooke1578 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-20-2012, 03:56 PM
  3. [SOLVED] Extract Substring, then Ignore that Substring, while collecting data from Other substrings
    By Sameki121 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-17-2012, 05:21 PM
  4. Return specific value if two conditions are met
    By livanoff in forum Excel General
    Replies: 3
    Last Post: 08-23-2011, 03:05 PM
  5. Searching a String for a Specific Substring
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-23-2005, 04:05 AM

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