"Formula is too long" error, but it is less than 1,024 characters

B

Bob_Duke

I'm trying to create a concatenate formula to produce an insert query for
Oracle. When I finish typing the formula and press Enter or click in the
worksheet, I get the error "Formula is too long." Just to eliminate outside
factors, I tried this simple formula in a blank worksheet:

=CONCATENATE("111111111111",A2,"111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111")

This formula is 505 characters in length, but I still get the error message.

Any thoughts?

Thanks in advance.
 
S

Simon Murphy

Bob
That third argument is too long, should be 255 chars max, if you split it
into 3 args your function will work fine

cheers
Simon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Too Long error in MS Excel 2
Formula to long error 2
Find and Replace. Formula Too Long Error Message. 1
Error Saving: "a formula in a cell... could not be converted..." 1
Can not replace commas - "formula too long" 7
Formula too long error 8
Why do I get error messages stating that my formulas are too long. 1
Expression exceeds 1,024 character limit... 4

Top