+ Reply to Thread
Results 1 to 12 of 12

Substitute or replace letters

Hybrid View

  1. #1
    Registered User
    Join Date
    05-15-2015
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2007
    Posts
    26

    Substitute or replace letters

    Hello, i neet to substitute or replace letters(characters) IFor example, if i have a word in latin letters, i need to transform the same word in cyrilic letters. If i have the word grass, to transform it to грасс (grass => грасс)
    i can make masiv with 2 rows with replaced any letter from latin to cyrilic, but then im not sure how to use the function with this masiv.
    i found something like this :
    1. A, А
    2. B, Б
    3. C, Ц
    4. D, Д

    Dim intCount As Long, intNum As Long
    intNum = UBound(strMasiv)

    For intCount = 0 To intNum Step 1
    strText = Replace(strText, strMasiv(intCount, 2), strMasiv(intCount, 1))
    Next intCount

    i need some help to complete this, or just to give me an example how to use is.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Substitute or replace letters

    с русским дружите?
    http://excelvba.ru/code/TranslitAddin
    http://excelvba.ru/code/translit

  3. #3
    Registered User
    Join Date
    05-15-2015
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2007
    Posts
    26

    Re: Substitute or replace letters

    Hello,thanks for the answer, i'm from Bulgaria. I need this, because somethimes we write in bulgarian but with latin characters, but i need the text in clear cyrilic. It works great, but is there a chance to make it with visible function or something, not with a macros. Because i need to edit the function and integrade logical data. So i thing something exactly like this but if it is possible to be without using of macros.

  4. #4
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Substitute or replace letters

    it's easy with one letter, what to do with reach or succeed
    you should upload a replace table

  5. #5
    Registered User
    Join Date
    05-15-2015
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2007
    Posts
    26

    Re: Substitute or replace letters

    Ok, but what function to use to replace the whole text at once?

  6. #6
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Substitute or replace letters

    table first

  7. #7
    Registered User
    Join Date
    05-15-2015
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2007
    Posts
    26

    Re: Substitute or replace letters

    ok here is the example of the table latin to cyrilic.png

  8. #8
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Substitute or replace letters

    this is a forum for excel not paint

  9. #9
    Registered User
    Join Date
    05-15-2015
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2007
    Posts
    26

    Re: Substitute or replace letters

    Sorry, i cant post the table here, i don't know why

  10. #10
    Registered User
    Join Date
    05-15-2015
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2007
    Posts
    26

    Re: Substitute or replace letters

    latin to cyrilic.xlsx
    here is the sample table

  11. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Substitute or replace letters

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  12. #12
    Registered User
    Join Date
    05-15-2015
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2007
    Posts
    26

    Re: Substitute or replace letters

    Thank you
    Attached Files Attached Files

+ 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. [SOLVED] Tricky SUBSTITUTE or REPLACE
    By bibu in forum Excel General
    Replies: 7
    Last Post: 03-16-2014, 01:38 PM
  2. want help to substitute all letters in a string at the same time
    By trickyricky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-20-2013, 06:57 PM
  3. [SOLVED] substitute/replace until
    By JanRaven in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-02-2012, 12:03 PM
  4. [SOLVED] [SOLVED] Replace/substitute
    By Viktor Ygdorff in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2006, 09:40 AM
  5. [SOLVED] Substitute/Replace
    By Viktor Ygdorff in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-17-2006, 07:40 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