Use the MID function...

=MID(A1,10,999)

The 999 needs to be a number larger than the longest piece of text that you
anticipate (it doesn't matter if the number is larger or not).

--
Rick (MVP - Excel)


"Scott" wrote in message
...
Hello,

I have a list of 1,000 rows of data and I want to remove the first 10
characters from each cell. I can't use the =RIGHT function because each
cell
has a different number of characters. Any ideas?

Thanks,
Scott