Results 1 to 3 of 3

Thread: Cut words from a cell and paste them into columns

  1. #1

    Cut words from a cell and paste them into columns



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi guys,


    In order to create a bi-lingual glossary, I'm in need of a function which must:


    1. cut from column 1 and paste in column 2, the word(s) contained between the sign "=" exclusively and the sign "(" also exclusively;
    2. cut also from column 1 and paste in column 3, the word(s) contained between the sign "(" inclusively, and the sign ")" also inclusively.
    This operation should be repeated for approximately 1500 lines.
    Should it simplify, you may generate one macro which does step 1 and another which does step 2, separately.


    Appreciate very much your help.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,356
    Articles
    0
    Excel Version
    365
    in B2:
    =MID(A2,FIND("=",A2)+1,FIND("(",A2)-FIND("=",A2)-1)

    in C2:
    =MID(A2,FIND("(",A2),FIND(")",A2)+1-FIND("(",A2))

    and copy down.

    ?

  3. #3
    Conjurer snb's Avatar
    Join Date
    May 2013
    Posts
    370
    Articles
    0
    Excel Version
    2020
    Is this an assignment ?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •