Removing first 10 characters of text

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

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

Why can't you use the RIGHT function?
What's wrong with =RIGHT(A1,LEN(A1)-10) ?
--
David Biddulph

Scott wrote:
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

Hi,

You can use either RIGHT or MID or

Select all the data in you 1000 rows, say A1:A1000 and choose Data, Text to
Columns, Fixed Width, Next. In the Preview pane click between the 10th and
11th characters - this will put in a line/arrow. Click Next. Select the 1st
column in the Preview pane and choose Do Not Import (Skip). Click Finish.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Scott" wrote:

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