How can I delete the first 3 characters of each cell, all differe.

[DGust]

I have a spreadsheet of data where one of the columns contains data that has
3 leading characters that I would like to strip off. All of the cells are
contain different characters so I can't do a global replace. An example:
cell = MCOP3257 and I would like to resultant cell to = P3257. Any help
would be greatly appreciated.

 

[Frank Kabel]

Hi
in an adjacent cell enter
=MID(A1,4,1024)

 

[DGust]

Frank,
I really feel dumb when it was such a simple function. Thank you very much!!

 

[Debra Dalgleish]

You could use the Text to Columns feature to delete the characters:

Select the cells that you want to change
Choose Data>Text to Columns
Select Fixed Width, click Next
In the Data Preview window, click after the third character,
to add a break line.
Click Next
With the first column selected, choose
'Do not import column (skip)'
Click Finish

 

[DGust]

Debra,
Another great way to solve my problem. Thanks much!