+ Reply to Thread
Results 1 to 3 of 3

Add [keyword] into existing text in cell

  1. #1
    Registered User
    Join Date
    10-07-2015
    Location
    Amsterdam
    MS-Off Ver
    2013
    Posts
    2

    Add [keyword] into existing text in cell

    Hi there,

    I am wondering if it possible to add a keyword from other cel into existing text i.e.

    I have this text:

    [position] jobs in [city]
    [position] jobs at [company]

    is there a formula that helps to automatically fill in this above mentioned field by taking this words from another cel?

    My excel skills are pretty basic, so I would appreciate if the answer is detailed.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: Add [keyword] into existing text in cell

    Can you explain more, like what data you're starting of with and what your expected result is?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    10-07-2015
    Location
    Amsterdam
    MS-Off Ver
    2013
    Posts
    2

    Re: Add [keyword] into existing text in cell

    Hi Special K,

    I have a standard text in a cel that should be used with multimple combination keywords but having the same structure. So the text is for instance:

    Marketing jobs in London
    or
    Marketing job at Microsoft

    So the goal is to have this standard text and by filling in the keywords in other (separate) cels this keywords will be insearted automaticly within the existing standrad text. So then you will have:

    [position] jobs in [city]

    And by filling in the position keyword in a separate cell it will take the keyword from that cel and paste it into the standard text. Imagine position is Acountmanager and city is Amsterdam it will automaticaly add it to the text and then I will be able to copy the prepared text "Acountmanager jobs in Amsterdam"

    I hope it's clear.

+ 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. Counting # of times keyword matches to a text string in a cell
    By abks in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-17-2015, 05:54 PM
  2. [SOLVED] adding text in front of potentially existing text (in 1 cell) with IF/THEN statement
    By Marijke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2014, 04:20 AM
  3. [SOLVED] Need to chck if a keyword is present in a text string and return keyword if yes
    By Jekaterina in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-16-2012, 05:55 PM
  4. Replies: 3
    Last Post: 11-28-2012, 09:00 AM
  5. Separating text using keyword in a cell
    By undergraduate in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2011, 02:53 PM
  6. Replies: 1
    Last Post: 06-13-2006, 12:10 PM
  7. Setting colour for new text inserted into existing text in a cell
    By wmauss in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-15-2005, 04:44 PM

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