Edited:

This should help with dropping end characters:

=MID(A1,2,LEN(A1)-2)

Though this may be what you actually want:

=SUBSTITUTE(A1&","&A2,"""","")

Hi Peter,

It work fine. I was hoping to run both cells with one formula. One value is in A1 the other is in B1.

A1

"AUDS"

B1

"Accessibility & Universal Design Services"

=MID(A1,2,LEN(A1)-2)

=MID(B1,2,LEN(B1)-2)

I just don't know how to tag the two together. I know that if a put them into two seperate cells then:

=MID(A1,2,LEN(A1)-2) put value into C1

=MID(B1,2,LEN(B1)-2) put value into D1

=SUBSTITUTE(C1&","&D1,"""","") put value into E1

I was hoping to put the "MID" command into one cell. if possable. This was I only have to run one last part and that is to SUBSTITUTE.

Bob