+ Reply to Thread
Results 1 to 9 of 9

Create sentences in Excel

  1. #1
    Registered User
    Join Date
    01-02-2011
    Location
    Tacoma
    MS-Off Ver
    Excel 2003
    Posts
    34

    Create sentences in Excel

    Hey I have about 1000 rows of data and I need to make a sentence for every row based on its information in its columns.

    For example, I have
    A B C
    The car is green




    how can I tell excel to put A + B + C (The car is green) in column D?

    thanks

  2. #2
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: Create sentences in Excel

    sorry it is

    Please Login or Register  to view this content.
    regards

    johnjohns

    When you are not sure where to go, every road takes you there!

  3. #3
    Forum Contributor
    Join Date
    07-29-2008
    Location
    New York
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    145

    Re: Create sentences in Excel

    zsemago,
    If the criteria for what color the car is is a combination of the letters A B and C in the exact order in columns A, B, and C respectively, then try this if I've interpreted your question correctly:
    Create a table in range G1:G7 with the following data (ABC in column G, and Green in column H, etc)

    ABC Green
    DEF Black
    HIJ White
    KLM Blue
    NOP Yellow
    QRS Magenta
    TUV Cyan
    Put A in cell A1, B in cell B1, and C in cell C1
    Then put the following formula in D1
    Please Login or Register  to view this content.

    Regards,
    Xrull

  4. #4
    Registered User
    Join Date
    01-02-2011
    Location
    Tacoma
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Create sentences in Excel

    Xrull, sorry I did not provide all the details

    Column A,B,C are more like Car, Green, Fast. So I would need to put the sentence together with extra words. The (A) is (B) and (C)

  5. #5
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: Create sentences in Excel

    can u please post a sample workbook with the expected result

  6. #6
    Registered User
    Join Date
    01-02-2011
    Location
    Tacoma
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Create sentences in Excel

    here it is.
    Attached Files Attached Files

  7. #7
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: Create sentences in Excel

    Perhaps this way, if you are filling up all the relevant columns.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    01-02-2011
    Location
    Tacoma
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Create sentences in Excel

    Thanks Johnjohns, this works nicely and I'll be using it.

    However I am going to inevitably have another problem. There is some missing data in my excel file. For example I don't have commentary on all of the lakes, so the column F will be blank sometimes. I want excel to recognize column F has no data and therefore not even make a sentence about F. So sentence 3 only happens if column F has something in it. I would like this to happen with column E (species) as well.


    Do you know how to do this?

  9. #9
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: Create sentences in Excel

    May be this way
    Attached Files Attached Files

+ 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