Maggie- I believe it is just misplaced parantheses. When I simplify your
formula to make it more readable for troubleshooting by breaking out the
three components of the IF statement, I get:

=IF(
LEN(CONCATENATE(C277))2,
LEFT(CONCATENATE(C277),LEN(concatenate(C277)-2))
[?]
)

The second statement is trying to subtract 2 from the concatenated string,
instead of the length of that string.

I think you want is:

=IF(
LEN(CONCATENATE(C277))2, [this part is ok]
LEFT(CONCATENATE(C277),LEN(concatenate(C277))-2), [moved a paranthesis,
added comma]
"" [added null-length string as the third statement]
)

This is aircode, but hopefully that points you in the right direction.
HTH,
Keith
"Maggie" wrote:

Nevermind I figured what was wrong, but now I am getting an error with
the formula to take out the comma and space. I get a #Name? when I
enter the formula. Here is my formula: =IF(LEN(CONCATENATE
(C277,D277,E278,F278,G278,H278))2, LEFT(CONCATENATE
(C277,D277,E278,F278,G278,H278),LEN(concatenate
(C277,D277,E278,F278,G278,H278)-2)))
My excell will not take the )-2),"") what am I doing wrong?