Trimming Data in Cell

[geno335]

How can I trim a certain number off of a string of data. For instance, I know about using the left and right functions, but what about if I want to remove, for instance, the first 6 characters from a string in a cell. How would you go about setting up that function?


ex- xxxxx- smith-xxxxxx-sss

and i want to be left with smith-xxxxxx-sss

or how about if i'm looking to get only the center part-
ex- xxxxx- smith-xxxxxx-sss

and i only want smith

Thanks.

 

[GlennUK]

To remove the first 6 characters from a cell , do something like:

=RIGHT(A2,LEN(A2)-6)

Look at the MID function for getting parts from the middle of a string.