Concatenate question.

[raywood]

My concatenate formula is giving me an extra quote in the result which I don't want or need, but each time I try to edit it I get an error. The parenthesis is correct....why the extra quote? Why do I get an error when I try to remove it?

=CONCATENATE(A1, " ( ",B1," ) """)
A1: 1-11-299-A
B1: 0510380496

Result:
1-11-299-A ( 0510380496 ) "

[xld]

Use

=A1&"("&B1&")"

[robert111]

=CONCATENATE(A1, " ( ",B1," ",")")

this tweaks your attempt rather than a different way of doing it.

[raywood]

Thanks for the quick assistance... I can go to lunch now.....solutions worked.