Al,

With the string Microsoft in A1
=LEFT(A1,3) returns 'Mic'
RIGHT(A1,6) returns 'rosoft
and in the same cell
=LEFT(A1,3)&RIGHT(A1,6)
Concatenates then together and returns 'Microsoft'

Mike



"Al" wrote:

Can somebody tell me how to use the Left and Right LEN command in the same
cell. I am trying to data from both ends... thanks Al