Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate Problem
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate problem | Excel Worksheet Functions | |||
Concatenate Problem | New Users to Excel | |||
Concatenate Problem | Excel Worksheet Functions | |||
concatenate problem | Excel Worksheet Functions | |||
Concatenate problem | Excel Programming |