Concatenate and then limit # of characters

S

SP

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
 
J

JulieD

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
 
S

SP

Thanks JulieD...I'm now trying a few other things based off of your feedback.
Curious though, what is the significance of the (Right/Left) is that
justification or from which end of the string it should count? Also, can I
make it count from the left but not start until after the second dash "-" or
some other character?
 
Top