+ Reply to Thread
Results 1 to 4 of 4

how to insert a single text from 1 cell to another

  1. #1
    Registered User
    Join Date
    07-03-2014
    Location
    sydney
    MS-Off Ver
    MS excel 2007
    Posts
    6

    how to insert a single text from 1 cell to another

    Hi the description of my problem may not be the best.

    This is my data set up:
    Cell A1 contains the text: Validate CB staging table fields map correctly to the L_CB_Joint_Share table without any transformation or data generation taking place.
    Cell A2 contains the text: Validate for target table L_CB_Joint_Share the "Auto Generated" and "Event_Log_Key" field data is auto created and not based on source data tables
    Cell A3 contains the text: Validate CB staging table fields map correctly to the L_CB_Joint_Share table based on the field specific transformation rules

    The 1 word that is common to all 3 cells is the word "L_CB_Joint_Share".

    I wanted to see is there a way in excel where I can have the word (or a variation) "L_CB_Joint_Share" auto populated to the other 2 cells in this case Cell A2 and A3.

    The common word will change from test case to test case but the rest of the wording for each of the cells will always be the same.

  2. #2
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: how to insert a single text from 1 cell to another

    Cell A1:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Cell A2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Cell A3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Where CaseName is a named range of one cell that contains the "L_CB_Joint_Share" or other name. You could also replace CaseName with a cell reference such as C3.
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.

  3. #3
    Registered User
    Join Date
    07-03-2014
    Location
    sydney
    MS-Off Ver
    MS excel 2007
    Posts
    6

    Re: how to insert a single text from 1 cell to another

    excellent...thanks...

  4. #4
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: how to insert a single text from 1 cell to another

    Post deleted
    Last edited by gak67; 07-16-2014 at 05:07 PM. Reason: Didn't look carefully enough.

+ 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. Insert picture into a single cell
    By meherts in forum Excel General
    Replies: 10
    Last Post: 04-16-2013, 02:09 AM
  2. [SOLVED] Insert a NAME into a text string in a single cell
    By cptkeith in forum Excel General
    Replies: 1
    Last Post: 12-17-2012, 06:04 PM
  3. Replies: 5
    Last Post: 09-26-2011, 03:12 AM
  4. how to insert a single cell
    By rs232 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2007, 12:04 PM
  5. [SOLVED] Insert a imge to a single cell
    By Geek in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-20-2006, 06:15 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