+ Reply to Thread
Results 1 to 3 of 3

Concatenating cell into a paragraph

  1. #1
    Registered User
    Join Date
    02-04-2013
    Location
    Florida, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Concatenating cell into a paragraph

    I am trying to concatenate one word in a cell to a paragraph. i get an error that text values are limited to 255 characters and that I should use the Concatenante functions... isn't that what I am doing? This is what I am entering:

    =CONCATENATE("It is understood that upon acceptance of this proposal, ",B10," has read and accepts each of the general conditions of this offer that should form integral part of the contract and/or purchase order. Likewise, it is stated and established that all the economic and technical information supplied in this offer is valid and refers only to the present offer. "

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Concatenating cell into a paragraph

    excel will only 255 characters in a cell. you already have far more than that

    Try breaking the phrase up into 3 parts, and then combining them again...

    A13 It is understood that upon acceptance of this proposal,
    A14 has read and accepts each of the general conditions of this offer that should form integral part of the contract and/or purchase order.
    A15 Likewise, it is stated and established that all the economic and technical information supplied in this offer is valid and refers only to the present offer.

    =A13&B10&A14&A15

    add spaces as needed. It's a way of tricking excel that the cell does not have 255 characters in it
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    02-04-2013
    Location
    Florida, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Concatenating cell into a paragraph

    Ok, I will try this.

    Thank you very much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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