+ Reply to Thread
Results 1 to 2 of 2

Copying and Pasting Long Formula from Word into Excel Cell

  1. #1
    Registered User
    Join Date
    05-26-2010
    Location
    Calgary, Canada
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Copying and Pasting Long Formula from Word into Excel Cell

    Hello,

    I'm trying to paste a formula (fairly simple - lots of the IF function) that I developed in Word for simplicity's sake into a cell in Excel. When I get it all in there and press enter, I get the following:

    "Text Values in formulas are limited to 255 characters. To create text values longer than 255 characters in a formula, use the CONCATENATE function or the CONCATENATE operator (&)."

    I know I can make a formula of this length (when I first built the formula, I did it within Excel, and it was longer than the current iteration) in Excel, so is there any solution short of typing out the whole thing into Excel (will take half an hour and likely errors...)?

    Any advice?

  2. #2
    Forum Contributor
    Join Date
    02-25-2010
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    174

    Re: Copying and Pasting Long Formula from Word into Excel Cell

    To shorten the function use named ranges in place of repeated columns/rows

    Also check for places where you are using tab names that are unnecasary

    Edit: Also that msg mean you are passing a variable in one of your functions that might surpass 255 chars, even if the entire formula does not.
    Last edited by DP978; 05-26-2010 at 05:54 PM.

+ 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