+ Reply to Thread
Results 1 to 6 of 6

Needing to modifiy contents of a cell with other cells

  1. #1
    Registered User
    Join Date
    05-27-2013
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Needing to modifiy contents of a cell with other cells

    So I have a need for some information heres the deal.

    I am using one cell as an incomplete template that needs to be modified using other cells

    In the one cell it contains this format(XXX representing the variable that I will input in another cell to complete the template).


    CELL A1
    Product Information: XXX
    Serial Number: XXX
    UPC Number: XXX
    Condition:XXX

    and so on I want all of this information and more contained in one cell, that is abled to be modified simply by typing information into a few other cells for each unique piece of information

    I assume this is possible. Would any one lend me their experience and impart some knowledge.

    Very much appreciated.

  2. #2
    Registered User
    Join Date
    01-14-2013
    Location
    United States
    MS-Off Ver
    2003 & 2010 - Excel, Word, PP, etc.
    Posts
    26

    Re: Needing to modifiy contents of a cell with other cells

    Attach a sample .xls file. It sounds like you might want to use concatenate formula, but your explanation is not clear without a sample.

  3. #3
    Registered User
    Join Date
    05-27-2013
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Re: Needing to modifiy contents of a cell with other cells

    I do not have excel or an xls for a sample, I will try and restate the question

    In Cell A1 It will be used for copying the contents of and pasting the completed information into web browsers.
    In Cell A1 You will find This information contained and formatted in one cell alone

    Figure-1
    A1=

    Information About Company
    Brief Story About Company
    Product Name: (X)
    UPC Number: (Y)
    Serial Number: (Z)
    Terms Of Sale
    Etc

    End Figure-1

    I want to essential Modify (X)(Y)(Z) using different cells one for each variable. "All completed information will be found inside of A1"

    Having Cell B1-B9 Being used as labels "Product Name" "UPC Number" "etc" and using cell C1-C9 to input variables for = (X)(Y)(Z)(ETC)

    In reality from cell A1 will change dynamically, but some information will need to stay constant.
    Every thing In B column will just be labels.
    Every thing In C will be for variables.

    I hope that makes sense, if not I will have to create an example tmrw while I am at work.
    Last edited by aficken213; 05-27-2013 at 06:03 PM.

  4. #4
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: Needing to modifiy contents of a cell with other cells

    I think you are saying that you have A1 which contains all your information and this is dependent on B1 and C1 etc...

    If so:

    In A1 --- =B1&C1 which joins the text together. Depending on hoe you enetr data in the cells you may need spaces in the formula so =A1&" "&B1 or even a colon =A1&": "&B1

    This can be repeating for several cells
    Say thanks, click *

  5. #5
    Registered User
    Join Date
    05-27-2013
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Re: Needing to modifiy contents of a cell with other cells

    A1 Is going to be my work area, Im creating a template which will reside in A1 it will contain constants and variables. Information Inside of A1 will be completed using other cells the variable parts of it, atleast that is the idea, I want it to retain all of the constants, but be able to be modified easily to alter the template as needed.

    pretend every thing in Fig-1 is found inside of one cell alone, how do I modify (X)(Y)(Z) using another cell
    Last edited by aficken213; 05-27-2013 at 06:04 PM.

  6. #6
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: Needing to modifiy contents of a cell with other cells

    Yeah what I mentioned is what you will need. Lets say in A1 you have the text "Platform: Master System Game: Alex the Kid" and you want to be able to type the platform in B1 and game in C1 and then have A1 reflect this.

    Change A1 to:

    ="Platform: "&B1&" Game: "&C1

    You just need to modify this to suit your work.
    Hope this helps.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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