I think you simply exceeded the limit of 30 arguments for the function by
adding the extra line
Try using & instead


"EW" wrote:

All -
I have a formula that I'm using on the spreedsheet (not in VB) that has been
concatenating the text of certain cells. I've run into a problem that is
telling me that "You have entered to many arguments for this fuction". Here
is an example of what I using:

Current formula:

=CONCATENATE("CCSL - PMHS Interval: ",AF30," EST: AHT: ",J2,"; Req.
Line: ",AG30,"; On-prod: ",AH30,".
PRO Interval: ",AF30," EST: AHT: ",J3,"; Req. Line: ",AI30,"; On-prod:
",AJ30,".
Combined Interval: ",AF30," EST: Req. Line: ",AM30,"; On-prod: ",AN30,".
")

What I'd like to have:

=CONCATENATE("CCSL - PMHS Interval: ", AF30, " EST: AHT: ", J2, "; Req.
Line: ", AG30, "; On-prod: " ,AH30, ".
PRO Interval: " ,AF30 ," EST: AHT: " ,J3 ,"; Req. Line: " ,AI30, "; On-prod:
" ,AJ30 ,". PROV: " ,AF30 ," EST: AHT: " ,J4 ,"; Req. Line: " ,AK30 ,"; On-prod:
" ,AL30 ,".
Combined Interval: " ,AF30 ," EST: Req. Line: " ,AM30 ,"; On-prod: " ,AN30 ,".
")

I added an extra line in the formula. Any help would be great.

Thanks in advance!