You've entered too many arguments for this function

[meppwc]

I have a formula that continues to return the same error message -- "You've entered too many arguments for this function"

I cannot understand what is wrong. The formula captures 15 cells (A2 through O2). All of the cells are "General" in format. Can someone please advise me of my error?

=CONCATENATE("insert into reject_assignment values (",A2,",'",B2,"','",C2,"','",D2,"','",E2,"','",F2,"','",G2,"','",H2,"','",I2,"','",J2,"','",K2,"','",L2,"','",M2,"','",N2,"','",O2,");")

If I remove cell O2, then it works.

 

[stuartford]

The max Concatenations is 30 think youve got 31 here Squire


Stu

 

[Norie]

Is that your exact formula?

If it is I don't think you've got the syntax right.

What exactly are you trying to concatenate?

PS Why the single quotes?

 

[levipe]

CONCATENATE() is limited to 30 items and you have 31. Try using just:

="insert into reject_assignment values ("&A2&",'"&B2&",'"&....etc

 

[meppwc]

Reply

Thanks for the assistance provide thus far..........the problem that I have is that I need to keep the "," in this statement because I need the comma as a delimiter to seperate each cell.

Is there anyway that this arguement can be written where as I don't have to place this delimiter in between each cell that is part of the overall arguement?

 

[barry houdini]

You could simply change the end of your formula from

O2,");")

to

O2)&");"

 

[meppwc]

Thanks

Sweet, I will give that a try

 

[meppwc]

Redefine the Problem

Sorry...........it is probably me missing the boat here. Let me provide a better example of what i am trying to achieve and what my end result is and needs to be...........

Because of the 30 argument restraint, I am ending up the what you see below when my overall equation hits 31. (Notice that the "O2" at the end should really be an asterik - *, which is the value witin the O2 cell.

insert into reject_assignment values (0,'MO','4761','*','*','*','*','*','*','*','*','*','*','*',',O2,');

It needs to look like this when all is said and done

insert into reject_assignment values (0,'MO','4761','*','*','*','*','*','*','*','*','*','*','*','*',);

 

[Norie]

If the problem is the 30 argument constraint then don't use CONCATENATE just use &.