+ Reply to Thread
Results 1 to 7 of 7

Replace array of letters altogether

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

    Replace array of letters altogether

    Hello everyone
    I need UDF function that enables me to replace a series of letters (array of letters) with another series of letters
    For example:
    I have the word "AKbAf" >> I need to replace each letter in this word :
    A would be G
    K would be N
    b would be h
    A would be G
    f would be o

    so the result would be "GNhGo"

    There is a table as an example of letters I need to replace in my attachment
    Note that I don't need to depend on this table itself
    I need to put the letters in two arrays .. (store letters in arrays) then replace each letter in the word with the suitable letter

    Hope it is clear
    Thanks advanced
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Replace array of letters altogether

    Here's something from an old book I have.
    Attached Files Attached Files
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

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

    Re: Replace array of letters altogether

    Thanks a lot Mr. skywriter for this gift
    How can I implement strMapIn and strMapOut in the UDF function itsfel?
    I tried but I failed

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Replace array of letters altogether

    Here it is with your file.
    Attached Files Attached Files

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

    Re: Replace array of letters altogether

    Thanks again Mr. skywriter
    I mean to do without the parameters (strMapIn & strMapOut )
    and use such lines in the UDF
    Please Login or Register  to view this content.

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

    Re: Replace array of letters altogether

    Thanks I could do it
    Please Login or Register  to view this content.

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

    Re: Replace array of letters altogether

    Thanks a lot Mr. Bruce for helping me ..
    You are perfect and awesome

+ 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. Substitute or replace letters
    By benbi in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-15-2015, 05:02 PM
  2. Go to another macro instead exit that sub altogether
    By keen2xl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2014, 08:06 AM
  3. Find and Replace when there are two of the same letters
    By amartino44 in forum Excel General
    Replies: 1
    Last Post: 03-17-2013, 06:23 PM
  4. Moving blank rows to the bottom of a sort or deleting them altogether.
    By a_bruno in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-19-2012, 06:49 PM
  5. replace first 2 letters only
    By nasser in forum Excel General
    Replies: 7
    Last Post: 10-09-2011, 06:26 AM
  6. Excel 2007 : Replace numbers by letters
    By pGrim in forum Excel General
    Replies: 4
    Last Post: 05-19-2011, 03:13 AM
  7. [SOLVED] How to link cells and keep number format altogether
    By Yi in forum Excel General
    Replies: 0
    Last Post: 05-06-2005, 10:06 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