Hi, i have data on my spreadsheet please see below
ME54001528
ME54001961
ME54002025
ME54002160
ME54001207
ME5EE120
ME5EE200
ME54000441
ME51831103
ME54002119
ME51842129
ME54001784
ME54001212
ME51842123
ME54001952
ME54002086
ME54001350
i want formula which should minus first three text characters or you
can say take away first three text digits and put rest of the text in
cell. I know the formulas of =LEFT and =RIGHT but i dont know how to
minus first three or last three text characters whith these formulas.
Is there anybody can help me