+ Reply to Thread
Results 1 to 6 of 6

Wrapping specified text in cell with <strong>#</strong> for Anki

  1. #1
    Registered User
    Join Date
    07-16-2019
    Location
    New Zealand
    MS-Off Ver
    365
    Posts
    44

    Wrapping specified text in cell with <strong>#</strong> for Anki

    I am unsure how I might accomplish this but suspect there may be a formula.

    In column A, I have the word I am learning in Anki. In column B, I have the text I would like to wrap (e.g., <strong>B1</strong>). And in column C, I have my desired output. Below is an example of what I would like to achieve. The solution must be able to recognise non-English text, e.g., ?, ?, and ?.

    Example:

    Column A

    sine
    ?vrig
    bog

    Column B

    i
    ?v
    g

    Column C

    s<strong>i</strong>ne
    <strong>?v</strong>rig
    bo<strong>g</strong>

    Any help is appreciated.

    EDIT: as you can see, this forum doesn't recognise Danish characters! The characters I am referring to are the three extra letters in the Danish alphabet.
    Last edited by TildesleyH; 09-19-2022 at 01:17 AM. Reason: Perfect response

  2. #2
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,203

    Re: Wrapping specified text in cell with <strong>#</strong> for Anki

    What should be the result for such an example:
    Col A: egzebegze
    Col B: gz
    Col C: e<strong>gz</strong>ebegze OR e<strong>gz</strong>ebe<strong>gz</strong>e OR something else?

    Artik

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,514

    Re: Wrapping specified text in cell with <strong>#</strong> for Anki

    TildesleyH,

    UDF
    Use in cell like

    =AddTag(A1,B1)

    Please Login or Register  to view this content.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Wrapping specified text in cell with <strong>#</strong> for Anki

    You can try Power Query
    Post any example in text file or excel file with original text and expected result
    Last edited by sandy666; 09-18-2022 at 10:01 PM.

  5. #5
    Registered User
    Join Date
    07-16-2019
    Location
    New Zealand
    MS-Off Ver
    365
    Posts
    44

    Re: Wrapping specified text in cell with <strong>#</strong> for Anki

    Thank you very much Jindon - you have just saved me HOURS!

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,514

    Re: Wrapping specified text in cell with <strong>#</strong> for Anki

    Quote Originally Posted by TildesleyH View Post
    Thank you very much Jindon
    N.P

    Just realized you don't need UDF.

    =SUBSTITUTE(A1,B1,"<strong>"&B1&"</strong>")

+ 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] Replacing Values in Text Strong Power query
    By JyothiGrace in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2022, 09:59 AM
  2. [JOB OPPORTUNITY] Looking for strong Excel macro and SQL skills
    By Michael Perry in forum The Water Cooler
    Replies: 0
    Last Post: 04-12-2019, 02:43 PM
  3. Help me convert a number strong to Date and time format, please.
    By tjwm202 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2018, 06:58 PM
  4. Drag&Drop pieces for my strong VBA chess engine
    By RZulu54 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-23-2016, 11:42 AM
  5. [SOLVED] How to protect excel sheet with a strong and recovery proof password!
    By jaysakle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2013, 08:24 AM
  6. getting strong with pivot tables and macro's
    By zazzz in forum Excel General
    Replies: 2
    Last Post: 06-24-2011, 07:34 AM
  7. Merge Cells In A Particular Column And Provide Strong Border
    By sreeks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-30-2010, 03:57 PM

Tags for this Thread

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