Need more info. Can you post an example of what you want to do including what
the original cell has in it and what you want the formula to return...
--
HTH...

Jim Thomlinson


"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