Results 1 to 1 of 1

Add substring to specific conditions

Threaded View

  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
    113011150869س113011150927
    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
    س9000
    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
    113011150869س9000س113011150927س9000
    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.

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