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

Removing first 10 characters of text
 

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

Removing first 10 characters of text
 

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

Removing first 10 characters of text
 

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