Hi Steve

=LEFT(CONCATENATE(A1," ", B1, " ", C1, " ", D1),26)
or
=RIGHT(CONCATENATE(A1," ", B1, " ", C1, " ", D1),26)
or
=LEFT(A1& " " & B1 & " " & C1 & " " & D1,26)
etc

Cheers
JulieD


"SP" wrote in message
...
I have a list of concatenated arguments that are two characters in length
for
each argument. How can I display only 26 characters of that output into
another cell (or limit to 26 within that cell)? Thanks, Steve